diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 4f539428e28..157de09b4ea 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -10317,6 +10317,12 @@ SELECT NULLIF(value, '(none)') ... <primary>array_prepend</primary> </indexterm> <indexterm> + <primary>array_remove</primary> + </indexterm> + <indexterm> + <primary>array_replace</primary> + </indexterm> + <indexterm> <primary>array_to_string</primary> </indexterm> <indexterm> @@ -10435,6 +10441,29 @@ SELECT NULLIF(value, '(none)') ... <row> <entry> <literal> + <function>array_remove</function>(<type>anyarray</type>, <type>anyelement</type>) + </literal> + </entry> + <entry><type>anyarray</type></entry> + <entry>remove all elements equal to the given value from the array + (array must be one-dimensional)</entry> + <entry><literal>array_remove(ARRAY[1,2,3,2], 2)</literal></entry> + <entry><literal>{1,3}</literal></entry> + </row> + <row> + <entry> + <literal> + <function>array_replace</function>(<type>anyarray</type>, <type>anyelement</type>, <type>anyelement</type>) + </literal> + </entry> + <entry><type>anyarray</type></entry> + <entry>replace each array element equal to the given value with a new value</entry> + <entry><literal>array_replace(ARRAY[1,2,5,4], 5, 3)</literal></entry> + <entry><literal>{1,2,3,4}</literal></entry> + </row> + <row> + <entry> + <literal> <function>array_to_string</function>(<type>anyarray</type>, <type>text</type> <optional>, <type>text</type></optional>) </literal> </entry> |