Nigel J. Andrews wrote:
>>
>>I gather that to mean SELECT DISTINCT ON (*) , ...
>>
>>Is the syntax give by "\h select" wrong or am I misinterpreting it?
>
>
> That's a misinterpretation I'm afraid. There is no comma shown before the *
> that is not part of the expression for the DISTINCT ON.
You mean "after the *" right? ;)
After looking at it again I see how I misunderstood the syntax. But I do
find it intuitive to say:
SELECT DISTINCT ON(c1) c2,c3 FROM ...
But I can live with it considering DISTINCT ON is non-standard SQL :)
--
Jean-Christian Imbeault