row_to_json question

[Joe Van Dyk <joe@xxxxxxxxx>]

How can I use row_to_json for a subset of columns in a row? (without
creating a new view or using a CTE?)

What I want returned:
{"email_address":"joe@xxxxxxxxx","username":"joevandyk"}
Note that there is no "id" column in the result.


create table users (id serial primary key, email_address varchar,
username varchar);
insert into users (email_address, username) values ('joe@xxxxxxxxx',
'joevandyk');

select row_to_json(users) from users;
 {"id":1,"email_address":"joe@xxxxxxxxx","username":"joevandyk"}
      Correct, except that the "id" column is in the result.


select row_to_json(row(users.email_address, users.username)) from users;
 {"f1":"joe@xxxxxxxxx","f2":"joevandyk"}
       The column names are incorrect.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general