On Wed, Jan 29, 2014 at 08:51:26PM +0000, Andrew Dunstan wrote: > Add json_array_elements_text function. > > This was a notable omission from the json functions added in 9.3 and > there have been numerous complaints about its absence. > > Laurence Rowe.
The docs seem to have bug: it says that the return value is SETOF json (http://www.postgresql.org/docs/devel/static/functions-json.html) While in reality (and based on name) it's setof text: (depesz@[local]:5930) 14:45:43 [depesz] $ \df json_array_elements_text List of functions Schema | Name | Result data type | Argument data types | Type ------------+--------------------------+------------------+--------------------------------+-------- pg_catalog | json_array_elements_text | SETOF text | from_json json, OUT value text | normal (1 row) Best regards, depesz
signature.asc
Description: Digital signature
