12 lines
293 B
Plaintext
12 lines
293 B
Plaintext
|
If the same logic is truly needed for both instances, then in an `IF` chain they should be combined.
|
||
|
|
|
||
|
|
[source,sql,diff-id=1,diff-type=compliant]
|
||
|
|
----
|
||
|
|
IF param = 1 OR param = 2 THEN
|
||
|
|
sort_order := 0;
|
||
|
|
column := 'LastName';
|
||
|
|
ELSE
|
||
|
|
sort_order := 1;
|
||
|
|
column := 'FirstName';
|
||
|
|
END IF;
|
||
|
|
----
|