diff options
| author | David Rowley <drowley@postgresql.org> | 2025-11-06 16:03:02 +1300 |
|---|---|---|
| committer | David Rowley <drowley@postgresql.org> | 2025-11-06 16:03:02 +1300 |
| commit | 49d43faa835f3c6817be9fc0b98bec0d661c2587 (patch) | |
| tree | 7e05c18da6489861271e5e84d260ac226a362275 /doc/src/sgml/func/func-binarystring.sgml | |
| parent | 6d0eba66275b125bf634bbdffda90c70856e3f93 (diff) | |
Doc: use uppercase keywords in SQLs
Use uppercase SQL keywords consistently throughout the documentation to
ease reading. Also add whitespace in a couple of places where it
improves readability.
Author: Erik Wienhold <ewie@ewie.name>
Reviewed-by: David Rowley <dgrowleyml@gmail.com>
Discussion: https://postgr.es/m/82eb512b-8ed2-46be-b311-54ffd26978c4%40ewie.name
Diffstat (limited to 'doc/src/sgml/func/func-binarystring.sgml')
| -rw-r--r-- | doc/src/sgml/func/func-binarystring.sgml | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/doc/src/sgml/func/func-binarystring.sgml b/doc/src/sgml/func/func-binarystring.sgml index dd7037811af..b256381e01f 100644 --- a/doc/src/sgml/func/func-binarystring.sgml +++ b/doc/src/sgml/func/func-binarystring.sgml @@ -151,7 +151,7 @@ of <parameter>newsubstring</parameter>. </para> <para> - <literal>overlay('\x1234567890'::bytea placing '\002\003'::bytea from 2 for 3)</literal> + <literal>overlay('\x1234567890'::bytea PLACING '\002\003'::bytea FROM 2 FOR 3)</literal> <returnvalue>\x12020390</returnvalue> </para></entry> </row> @@ -170,7 +170,7 @@ <parameter>bytes</parameter>, or zero if it's not present. </para> <para> - <literal>position('\x5678'::bytea in '\x1234567890'::bytea)</literal> + <literal>position('\x5678'::bytea IN '\x1234567890'::bytea)</literal> <returnvalue>3</returnvalue> </para></entry> </row> @@ -211,7 +211,7 @@ and <parameter>count</parameter>. </para> <para> - <literal>substring('\x1234567890'::bytea from 3 for 2)</literal> + <literal>substring('\x1234567890'::bytea FROM 3 FOR 2)</literal> <returnvalue>\x5678</returnvalue> </para></entry> </row> @@ -856,8 +856,8 @@ significant byte first. Some examples: <programlisting> 1234::smallint::bytea <lineannotation>\x04d2</lineannotation> -cast(1234 as bytea) <lineannotation>\x000004d2</lineannotation> -cast(-1234 as bytea) <lineannotation>\xfffffb2e</lineannotation> +cast(1234 AS bytea) <lineannotation>\x000004d2</lineannotation> +cast(-1234 AS bytea) <lineannotation>\xfffffb2e</lineannotation> '\x8000'::bytea::smallint <lineannotation>-32768</lineannotation> '\x8000'::bytea::integer <lineannotation>32768</lineannotation> </programlisting> |