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.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
