Re: SELECT DISTINCT ON bug?

On Wed, 21 May 2003, Jean-Christian Imbeault wrote:

> Martijn van Oosterhout wrote:
> >
> > Drop the comma after the distinct on.
> >
> > SELECT distinct on(dai_genres.id) dsc from dai_genres,
>
> Ok, that worked. But accroding to "\h select" the syntax is:
>
> SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
>      * | expression [ AS output_name ] [, ...]
>
>
> 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.


--
Nigel J. Andrews