From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: SELECT DISTINCT ON bug? |
Date: | 2003-05-21 07:41:31 |
Message-ID: | 20030521074127.GE18900@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)svana(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Christian Imbeault | 2003-05-21 08:08:33 | Re: SELECT DISTINCT ON bug? |
Previous Message | Shridhar Daithankar | 2003-05-21 06:36:36 | Re: [GENERAL] pam-linux, /etc/shadow : HOW-TO |