diff options
Diffstat (limited to 'doc/src/sgml/syntax.sgml')
-rw-r--r-- | doc/src/sgml/syntax.sgml | 21 |
1 files changed, 16 insertions, 5 deletions
diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index 4b81b088823..8283e252582 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -2596,10 +2596,10 @@ SELECT concat_lower_or_upper('Hello', 'World'); <para> In named notation, each argument's name is specified using - <literal>:=</literal> to separate it from the argument expression. + <literal>=></literal> to separate it from the argument expression. For example: <screen> -SELECT concat_lower_or_upper(a := 'Hello', b := 'World'); +SELECT concat_lower_or_upper(a => 'Hello', b => 'World'); concat_lower_or_upper ----------------------- hello world @@ -2610,13 +2610,24 @@ SELECT concat_lower_or_upper(a := 'Hello', b := 'World'); using named notation is that the arguments may be specified in any order, for example: <screen> -SELECT concat_lower_or_upper(a := 'Hello', b := 'World', uppercase := true); +SELECT concat_lower_or_upper(a => 'Hello', b => 'World', uppercase => true); concat_lower_or_upper ----------------------- HELLO WORLD (1 row) -SELECT concat_lower_or_upper(a := 'Hello', uppercase := true, b := 'World'); +SELECT concat_lower_or_upper(a => 'Hello', uppercase => true, b => 'World'); + concat_lower_or_upper +----------------------- + HELLO WORLD +(1 row) +</screen> + </para> + + <para> + An older syntax based on ":=" is supported for backward compatibility: +<screen> + SELECT concat_lower_or_upper(a := 'Hello', uppercase := true, b := 'World'); concat_lower_or_upper ----------------------- HELLO WORLD @@ -2638,7 +2649,7 @@ SELECT concat_lower_or_upper(a := 'Hello', uppercase := true, b := 'World'); already mentioned, named arguments cannot precede positional arguments. For example: <screen> -SELECT concat_lower_or_upper('Hello', 'World', uppercase := true); +SELECT concat_lower_or_upper('Hello', 'World', uppercase => true); concat_lower_or_upper ----------------------- HELLO WORLD |