Greg Stark <[email protected]> writes: > On Wed, Nov 4, 2009 at 3:17 AM, Emmanuel Cecchet <[email protected]> wrote: >> 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? Presumably something before this bug http://archives.postgresql.org/pgsql-sql/2008-07/msg00123.php got fixed http://archives.postgresql.org/pgsql-committers/2008-07/msg00341.php regards, tom lane -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
