returning json data row from json query

["john.tiger" <john.tigernassau@xxxxxxxxx>]

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