Re: DISTINCT ON - Mailing list pgsql-hackers

From Greg Stark
Subject Re: DISTINCT ON
Date
Msg-id 407d949e0911032006w21b1654dqc75ba3e0e462a496@mail.gmail.com
Whole thread Raw
In response to DISTINCT ON  (Emmanuel Cecchet <manu@asterdata.com>)
Responses Re: DISTINCT ON
List pgsql-hackers
On Wed, Nov 4, 2009 at 3:17 AM, Emmanuel Cecchet <manu@asterdata.com> wrote:

> For example, this query returns an error (but I guess it shouldn't):
>
> SELECT DISTINCT ON ('1'::varchar,  '1'::varchar) a FROM (SELECT 1 AS a) AS a
> ORDER BY '1'::varchar, '1'::varchar, '2'::varchar;

This sounds familiar.  What version of Postgres are you testing this on?

--
greg


pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Architecture of walreceiver (Streaming Replication)
Next
From: Robert Haas
Date:
Subject: Re: DISTINCT ON