Re: [GENERAL] returning json data row from json query

On Sat, Jan 4, 2014 at 1:44 AM, David Johnston wrote: > john.tiger wrote >> select * from users where jsondata->>'username' = 'jdoe' works but >> returns field names, etc besides the data row.how can we get json >> data back ? >> >> select row_to_json from users where jsondata->>'username'='jd

Re: [GENERAL] returning json data row from json query

john.tiger wrote > select * from users where jsondata->>'username' = 'jdoe' works but > returns field names, etc besides the data row.how can we get json > data back ? > > select row_to_json from users where jsondata->>'username'='jdoe' didn't > work. > > any ideas ? thks. Using what clie

[GENERAL] returning json data row from json query

select * from users where jsondata->>'username' = 'jdoe' works but returns field names, etc besides the data row.how can we get json data back ? select row_to_json from users where jsondata->>'username'='jdoe' didn't work. any ideas ? thks. -- Sent via pgsql-general mailing list (pgsql