News for hackers. Stuff that matters.
Re:Heroku Postgres: SQL Database-as-a-Service by einhverfr on Wednesday November 23, 2011 @01:37AM (#3269066)
you can do the same in PostgreSQL with joins.

For example:

select i.* , array_agg(ROW(l.*)::text)

from invoice i

join invoice_line l ON i.id = l.invoice_id

where i.id = 1023;

This returns a single row for invoice, along with an array of tuples representation of all invoice lines. You could also use casts and stored procedure languages to convert to xml or whatever if you want.

There are no comments on this comment yet.