|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.439 2008/07/07 16:11:35 petere Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.440 2008/07/15 18:24:59 momjian Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="functions"> |
4 | 4 | <title>Functions and Operators</title> |
@@ -9340,87 +9340,87 @@ SELECT NULLIF(value, '(none)') ... |
9340 | 9340 | <tbody> |
9341 | 9341 | <row> |
9342 | 9342 | <entry> |
9343 | | - <literal> |
9344 | | - <function>array_append</function>(<type>anyarray</type>, <type>anyelement</type>) |
9345 | | - </literal> |
9346 | | - </entry> |
| 9343 | +<literal> |
| 9344 | +<function>array_append</function>(<type>anyarray</type>, <type>anyelement</type>) |
| 9345 | +</literal> |
| 9346 | +</entry> |
9347 | 9347 | <entry><type>anyarray</type></entry> |
9348 | 9348 | <entry>append an element to the end of an array</entry> |
9349 | 9349 | <entry><literal>array_append(ARRAY[1,2], 3)</literal></entry> |
9350 | 9350 | <entry><literal>{1,2,3}</literal></entry> |
9351 | 9351 | </row> |
9352 | 9352 | <row> |
9353 | 9353 | <entry> |
9354 | | - <literal> |
9355 | | - <function>array_cat</function>(<type>anyarray</type>, <type>anyarray</type>) |
9356 | | - </literal> |
9357 | | - </entry> |
| 9354 | +<literal> |
| 9355 | +<function>array_cat</function>(<type>anyarray</type>, <type>anyarray</type>) |
| 9356 | +</literal> |
| 9357 | +</entry> |
9358 | 9358 | <entry><type>anyarray</type></entry> |
9359 | 9359 | <entry>concatenate two arrays</entry> |
9360 | 9360 | <entry><literal>array_cat(ARRAY[1,2,3], ARRAY[4,5])</literal></entry> |
9361 | 9361 | <entry><literal>{1,2,3,4,5}</literal></entry> |
9362 | 9362 | </row> |
9363 | 9363 | <row> |
9364 | 9364 | <entry> |
9365 | | - <literal> |
9366 | | - <function>array_dims</function>(<type>anyarray</type>) |
9367 | | - </literal> |
9368 | | - </entry> |
| 9365 | +<literal> |
| 9366 | +<function>array_dims</function>(<type>anyarray</type>) |
| 9367 | +</literal> |
| 9368 | +</entry> |
9369 | 9369 | <entry><type>text</type></entry> |
9370 | 9370 | <entry>returns a text representation of array's dimensions</entry> |
9371 | 9371 | <entry><literal>array_dims(ARRAY[[1,2,3], [4,5,6]])</literal></entry> |
9372 | 9372 | <entry><literal>[1:2][1:3]</literal></entry> |
9373 | 9373 | </row> |
9374 | 9374 | <row> |
9375 | 9375 | <entry> |
9376 | | - <literal> |
9377 | | - <function>array_lower</function>(<type>anyarray</type>, <type>int</type>) |
9378 | | - </literal> |
9379 | | - </entry> |
| 9376 | +<literal> |
| 9377 | +<function>array_lower</function>(<type>anyarray</type>, <type>int</type>) |
| 9378 | +</literal> |
| 9379 | +</entry> |
9380 | 9380 | <entry><type>int</type></entry> |
9381 | 9381 | <entry>returns lower bound of the requested array dimension</entry> |
9382 | 9382 | <entry><literal>array_lower('[0:2]={1,2,3}'::int[], 1)</literal></entry> |
9383 | 9383 | <entry><literal>0</literal></entry> |
9384 | 9384 | </row> |
9385 | 9385 | <row> |
9386 | 9386 | <entry> |
9387 | | - <literal> |
9388 | | - <function>array_prepend</function>(<type>anyelement</type>, <type>anyarray</type>) |
9389 | | - </literal> |
9390 | | - </entry> |
| 9387 | +<literal> |
| 9388 | +<function>array_prepend</function>(<type>anyelement</type>, <type>anyarray</type>) |
| 9389 | +</literal> |
| 9390 | +</entry> |
9391 | 9391 | <entry><type>anyarray</type></entry> |
9392 | 9392 | <entry>append an element to the beginning of an array</entry> |
9393 | 9393 | <entry><literal>array_prepend(1, ARRAY[2,3])</literal></entry> |
9394 | 9394 | <entry><literal>{1,2,3}</literal></entry> |
9395 | 9395 | </row> |
9396 | 9396 | <row> |
9397 | 9397 | <entry> |
9398 | | - <literal> |
9399 | | - <function>array_to_string</function>(<type>anyarray</type>, <type>text</type>) |
9400 | | - </literal> |
9401 | | - </entry> |
| 9398 | +<literal> |
| 9399 | +<function>array_to_string</function>(<type>anyarray</type>, <type>text</type>) |
| 9400 | +</literal> |
| 9401 | +</entry> |
9402 | 9402 | <entry><type>text</type></entry> |
9403 | 9403 | <entry>concatenates array elements using provided delimiter</entry> |
9404 | 9404 | <entry><literal>array_to_string(ARRAY[1, 2, 3], '~^~')</literal></entry> |
9405 | 9405 | <entry><literal>1~^~2~^~3</literal></entry> |
9406 | 9406 | </row> |
9407 | 9407 | <row> |
9408 | 9408 | <entry> |
9409 | | - <literal> |
9410 | | - <function>array_upper</function>(<type>anyarray</type>, <type>int</type>) |
9411 | | - </literal> |
9412 | | - </entry> |
| 9409 | +<literal> |
| 9410 | +<function>array_upper</function>(<type>anyarray</type>, <type>int</type>) |
| 9411 | +</literal> |
| 9412 | +</entry> |
9413 | 9413 | <entry><type>int</type></entry> |
9414 | 9414 | <entry>returns upper bound of the requested array dimension</entry> |
9415 | 9415 | <entry><literal>array_upper(ARRAY[1,2,3,4], 1)</literal></entry> |
9416 | 9416 | <entry><literal>4</literal></entry> |
9417 | 9417 | </row> |
9418 | 9418 | <row> |
9419 | 9419 | <entry> |
9420 | | - <literal> |
9421 | | - <function>string_to_array</function>(<type>text</type>, <type>text</type>) |
9422 | | - </literal> |
9423 | | - </entry> |
| 9420 | +<literal> |
| 9421 | +<function>string_to_array</function>(<type>text</type>, <type>text</type>) |
| 9422 | +</literal> |
| 9423 | +</entry> |
9424 | 9424 | <entry><type>text[]</type></entry> |
9425 | 9425 | <entry>splits string into array elements using provided delimiter</entry> |
9426 | 9426 | <entry><literal>string_to_array('xx~^~yy~^~zz', '~^~')</literal></entry> |
|