[GENERAL] returning json data row from json query

[john.tiger]

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-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general