Re: DISTINCT ON

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Emmanuel Cecchet <manu(at)asterdata(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DISTINCT ON
Date: 2009-11-04 04:06:53
Message-ID: 407d949e0911032006w21b1654dqc75ba3e0e462a496@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Nov 4, 2009 at 3:17 AM, Emmanuel Cecchet <manu(at)asterdata(dot)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

In response to

  • DISTINCT ON at 2009-11-04 03:17:06 from Emmanuel Cecchet

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-11-04 04:36:28 Re: DISTINCT ON
Previous Message Fujii Masao 2009-11-04 03:17:51 Re: Architecture of walreceiver (Streaming Replication)