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-string.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-string.sgml')
| -rw-r--r-- | doc/src/sgml/func/func-string.sgml | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/doc/src/sgml/func/func-string.sgml b/doc/src/sgml/func/func-string.sgml index 01cc94c234e..7ad1436e5f8 100644 --- a/doc/src/sgml/func/func-string.sgml +++ b/doc/src/sgml/func/func-string.sgml @@ -328,7 +328,7 @@ of <parameter>newsubstring</parameter>. </para> <para> - <literal>overlay('Txxxxas' placing 'hom' from 2 for 4)</literal> + <literal>overlay('Txxxxas' PLACING 'hom' FROM 2 FOR 4)</literal> <returnvalue>Thomas</returnvalue> </para></entry> </row> @@ -347,7 +347,7 @@ <parameter>string</parameter>, or zero if it's not present. </para> <para> - <literal>position('om' in 'Thomas')</literal> + <literal>position('om' IN 'Thomas')</literal> <returnvalue>3</returnvalue> </para></entry> </row> @@ -411,15 +411,15 @@ and <parameter>count</parameter>. </para> <para> - <literal>substring('Thomas' from 2 for 3)</literal> + <literal>substring('Thomas' FROM 2 FOR 3)</literal> <returnvalue>hom</returnvalue> </para> <para> - <literal>substring('Thomas' from 3)</literal> + <literal>substring('Thomas' FROM 3)</literal> <returnvalue>omas</returnvalue> </para> <para> - <literal>substring('Thomas' for 2)</literal> + <literal>substring('Thomas' FOR 2)</literal> <returnvalue>Th</returnvalue> </para></entry> </row> @@ -434,7 +434,7 @@ <xref linkend="functions-posix-regexp"/>. </para> <para> - <literal>substring('Thomas' from '...$')</literal> + <literal>substring('Thomas' FROM '...$')</literal> <returnvalue>mas</returnvalue> </para></entry> </row> @@ -455,7 +455,7 @@ and should be considered obsolete. </para> <para> - <literal>substring('Thomas' similar '%#"o_a#"_' escape '#')</literal> + <literal>substring('Thomas' SIMILAR '%#"o_a#"_' ESCAPE '#')</literal> <returnvalue>oma</returnvalue> </para></entry> </row> |