Tom Lane wrote:
Greg Stark <gsst...@mit.edu> writes:
On Wed, Nov 4, 2009 at 3:17 AM, Emmanuel Cecchet <m...@asterdata.com> 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
I am using 8.3.6 and it looks like the fix was only integrated in 8.4.
So using 8.4 should solve the problem.
Thanks
Emmanuel
--
Emmanuel Cecchet
Aster Data
Web: http://www.asterdata.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
