On 12/3/2017 3:18 PM, Yuri Budilov wrote:
> |CREATETABLEX ASSELECTjson_array_elements(json_rmq
> ->'orders'::text)ASorderFROMtable_name WHEREblah;|
>
> I get out of memory error.
are you sure thats a postgres error ? are you doing this in psql, or
what sort of application environment ?
how many rows does 'blah' match ?
what is...
SELECT pg_column_size(json_array_elements(json_rmq -> 'orders'::text))
FROM table_name
WHERE blah;
?
--
john r pierce, recycling bits in santa cruz