> Chris Bitmead <chris@bitmead.com> writes:
> > As long as we're fixing the syntax, I'm wondering if it wouldn't be more
> > logical to have DISTINCT ON somewhere later in the syntax.
>
> Well, SELECT DISTINCT is that way because SQL92 says so. Putting the
> DISTINCT ON variant somewhere else might be logically purer, but I think
> it'd be confusing.
>
> Also, isn't the reason we have DISTINCT ON at all that it's there to
> be compatible with MySQL or someone? I figured adding parens would be
> about the least-surprising variant syntax for a person used to those
> other products.
>
Makes sense to me.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026