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:ByrneJB@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