pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Subselect returning 2 columns 2+ messages / 2 participants [nested] [flat]
* Subselect returning 2 columns @ 2004-05-06 08:52 Francesc Leveque <webmaster@loroadictos.com> 0 siblings, 1 reply; 2+ messages in thread From: Francesc Leveque @ 2004-05-06 08:52 UTC (permalink / raw) To: pgsql-sql Hello, Is correct to do something like?: SELECT row1,row2 FROM mytable WHERE (row1,row3) IN (SELECT row1 as p1,MAX(row3) as p2 FROM mytable WHERE row3 <= current_date GROUP BY row1) I mean, I don't see documentation about subselects returning more than one column, but it seems to work... Thanks, Francesc. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Subselect returning 2 columns @ 2004-05-07 01:26 Tom Lane <tgl@sss.pgh.pa.us> parent: Francesc Leveque <webmaster@loroadictos.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2004-05-07 01:26 UTC (permalink / raw) To: Francesc Leveque <webmaster@loroadictos.com>; +Cc: pgsql-sql Francesc Leveque <webmaster@loroadictos.com> writes: > Is correct to do something like?: > SELECT row1,row2 FROM mytable > WHERE (row1,row3) IN > (SELECT row1 as p1,MAX(row3) as p2 FROM mytable > WHERE row3 <= current_date > GROUP BY row1) Sure. > I mean, I don't see documentation about subselects returning more than > one column, but it seems to work... http://www.postgresql.org/docs/7.4/static/functions-subquery.html#AEN12497 regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-05-07 01:26 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-05-06 08:52 Subselect returning 2 columns Francesc Leveque <webmaster@loroadictos.com> 2004-05-07 01:26 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox