On 18 Jan 2011, at 19:59, James B. Byrne wrote: > > On Tue, January 18, 2011 13:23, Alban Hertroys wrote: >> >> >> Standard SQL alternatives tend to get complex, using self-joins to >> weed out all the records you don't want (the exact term for such >> joins escapes me right now, that would help with Googling if you're >> looking for examples). > > Would the term be a grouped self join? Nope, but some Googling put me on the right track. It's called a correlated subquery. > 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 :) Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:737,4d35e9d011708045415059! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
