<!--

$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.244 2005/04/01 14:25:22 momjian Exp $

$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.245 2005/04/13 00:20:10 neilc Exp $

PostgreSQL documentation

-->

</entry>

<entry><type>text</type></entry>

<entry>returns a text representation of array's dimensions</entry>

<entry><literal>array_dims(array[[1,2,3], [4,5,6]])</literal></entry>

<entry><literal>array_dims(ARRAY[[1,2,3], [4,5,6]])</literal></entry>

<entry><literal>[1:2][1:3]</literal></entry>

</row>

<row>

</entry>

<entry><type>text</type></entry>

<entry>concatenates array elements using provided delimiter</entry>

<entry><literal>array_to_string(array[1, 2, 3], '~^~')</literal></entry>

<entry><literal>array_to_string(ARRAY[1, 2, 3], '~^~')</literal></entry>

<entry><literal>1~^~2~^~3</literal></entry>

</row>

<row>

</entry>

<entry><type>text[]</type></entry>

<entry>splits string into array elements using provided delimiter</entry>

<entry><literal>string_to_array('xx~^~yy~^~zz', '~^~')</literal></entry>

<entry><literal>string_to_array('xx~^~yy~^~zz', '~^~')</literal></entry>

<entry><literal>{xx,yy,zz}</literal></entry>

</row>

</tbody>