Home > mailing lists

json_array_elements_text? - Mailing list pgsql-general

From	Laurence Rowe
Subject	json_array_elements_text?
Date	January 17, 2014 08:20:11
Msg-id	CAOycyLQcR=Fr6QzLpe_AL10oVPxkpA-jA1jniZ7JuAsZsSf30w@mail.gmail.com Whole thread Raw
Responses	Re: json_array_elements_text?
List	pgsql-general

Tree view

Hello,

I'm trying to unpack a json array into it's constituent text values so I can join them to a table. I can successfully unpack json values, but am having trouble converting these to text so I can cast them to the UUIDs needed for the join.

http://dba.stackexchange.com/questions/54283/how-to-turn-json-array-into-postgres-array suggest using trim, and this does work:

SELECT trim(json_array_elements(biosample.properties->'treatments')::text, '"')::uuid

FROM object biosample WHERE biosample.item_type = 'biosample'

But it seems kinda ugly. Am I missing something obvious or is postgres 9.3 just missing a json_array_elements_text function?

Laurence

pgsql-general by date:

From: Chris Travers
Date: 17 January 2014, 07:29:42
Subject: Re: PostgreSQL with ZFS on Linux

From: Sameer Kumar
Date: 17 January 2014, 09:17:43
Subject: Re: Correct query to check streaming replication lag

json_array_elements_text? - Mailing list pgsql-general

Previous

Next