On Tue, January 18, 2011 14:28, Alban Hertroys wrote: > > Nope, but some Googling put me on the right track. It's called a > correlated subquery.
Thank you for this. I will delve further. >> I can see the motivation for something like DISTINCT ON. I take >> it that this syntax is peculiar to PostgreSQL?: > > > I suppose you meant particular? Yes, definitely. Although I'm sure > some would find it peculiar as well :) No. I meant peculiar. As in characteristic of only one person, group, or thing; distinctive . . . to PostgreSQL Regards, -- *** E-Mail is NOT a SECURE channel *** James B. Byrne mailto:byrn...@harte-lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general