diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 21 | ||||
| -rw-r--r-- | doc/src/sgml/spgist.sgml | 1 |
2 files changed, 22 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 5abb1c46fbb..9a1efc14cf7 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -2277,6 +2277,21 @@ <row> <entry> <indexterm> + <primary>starts_with</primary> + </indexterm> + <literal><function>starts_with(<parameter>string</parameter>, <parameter>prefix</parameter>)</function></literal> + </entry> + <entry><type>bool</type></entry> + <entry> + Returns true if <parameter>string</parameter> starts with <parameter>prefix</parameter>. + </entry> + <entry><literal>starts_with('alphabet', 'alph')</literal></entry> + <entry><literal>t</literal></entry> + </row> + + <row> + <entry> + <indexterm> <primary>to_ascii</primary> </indexterm> <literal><function>to_ascii(<parameter>string</parameter> <type>text</type> @@ -4033,6 +4048,12 @@ cast(-44 as bit(12)) <lineannotation>111111010100</lineannotation> ILIKE</function>, respectively. All of these operators are <productname>PostgreSQL</productname>-specific. </para> + + <para> + There is also the prefix operator <literal>^@</literal> and corresponding + <function>starts_with</function> function which covers cases when only + searching by beginning of the string is needed. + </para> </sect2> diff --git a/doc/src/sgml/spgist.sgml b/doc/src/sgml/spgist.sgml index e47f70be89b..06b75190522 100644 --- a/doc/src/sgml/spgist.sgml +++ b/doc/src/sgml/spgist.sgml @@ -161,6 +161,7 @@ <literal>~<~</literal> <literal>~>=~</literal> <literal>~>~</literal> + <literal>^@</literal> </entry> </row> <row> |