summaryrefslogtreecommitdiff
path: root/doc/src/sgml/func/func-bitstring.sgml
diff options
context:
space:
mode:
authorDavid Rowley <drowley@postgresql.org>2025-11-06 16:03:02 +1300
committerDavid Rowley <drowley@postgresql.org>2025-11-06 16:03:02 +1300
commit49d43faa835f3c6817be9fc0b98bec0d661c2587 (patch)
tree7e05c18da6489861271e5e84d260ac226a362275 /doc/src/sgml/func/func-bitstring.sgml
parent6d0eba66275b125bf634bbdffda90c70856e3f93 (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-bitstring.sgml')
-rw-r--r--doc/src/sgml/func/func-bitstring.sgml8
1 files changed, 4 insertions, 4 deletions
diff --git a/doc/src/sgml/func/func-bitstring.sgml b/doc/src/sgml/func/func-bitstring.sgml
index f03dd63afcc..3f59de464a4 100644
--- a/doc/src/sgml/func/func-bitstring.sgml
+++ b/doc/src/sgml/func/func-bitstring.sgml
@@ -251,7 +251,7 @@
of <parameter>newsubstring</parameter>.
</para>
<para>
- <literal>overlay(B'01010101010101010' placing B'11111' from 2 for 3)</literal>
+ <literal>overlay(B'01010101010101010' PLACING B'11111' FROM 2 FOR 3)</literal>
<returnvalue>0111110101010101010</returnvalue>
</para></entry>
</row>
@@ -269,7 +269,7 @@
within <parameter>bits</parameter>, or zero if it's not present.
</para>
<para>
- <literal>position(B'010' in B'000001101011')</literal>
+ <literal>position(B'010' IN B'000001101011')</literal>
<returnvalue>8</returnvalue>
</para></entry>
</row>
@@ -290,7 +290,7 @@
and <parameter>count</parameter>.
</para>
<para>
- <literal>substring(B'110010111111' from 3 for 2)</literal>
+ <literal>substring(B'110010111111' FROM 3 FOR 2)</literal>
<returnvalue>00</returnvalue>
</para></entry>
</row>
@@ -348,7 +348,7 @@
<programlisting>
44::bit(10) <lineannotation>0000101100</lineannotation>
44::bit(3) <lineannotation>100</lineannotation>
-cast(-44 as bit(12)) <lineannotation>111111010100</lineannotation>
+cast(-44 AS bit(12)) <lineannotation>111111010100</lineannotation>
'1110'::bit(4)::integer <lineannotation>14</lineannotation>
</programlisting>
Note that casting to just <quote>bit</quote> means casting to