Re: SELECT DISTINCT ON bug? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: SELECT DISTINCT ON bug?
Date
Msg-id 20030521074127.GE18900@svana.org
Whole thread Raw
In response to SELECT DISTINCT ON bug?  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
On Wed, May 21, 2003 at 03:35:37PM +0900, Jean-Christian Imbeault wrote:
> The following query give an error in 7.3
>
> TAL=# SELECT distinct on(dai_genres.id), dsc from dai_genres,
> rel_genres_goods where dai_genres.id=rel_genres_goods.major_id group by
> id, dsc;
> ERROR:  parser: parse error at or near "," at character 34

Drop the comma after the distinct on.

SELECT distinct on(dai_genres.id) dsc from dai_genres,


--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington

Attachment

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: pam-linux, /etc/shadow : HOW-TO
Next
From: Jean-Christian Imbeault
Date:
Subject: Re: SELECT DISTINCT ON bug?