Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.3.2: test select_having ... FAILED - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.3.2: test select_having ... FAILED
Date
Msg-id 16808.1044910247@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.3.2: test select_having ... FAILED  ("Ed L." <pggeneral@bluepolka.net>)
Responses Re: 7.3.2: test select_having ... FAILED  ("Ed L." <pggeneral@bluepolka.net>)
List pgsql-general
Tree view 
"Ed L." <pggeneral@bluepolka.net> writes:
> The select_having regression test fails pg 7.3.2 just as it did in
> 7.3.1.  Upon inspection, the 7.3.2 code (select_having.sql) does not
> include the "ORDER BY" clauses needed to pass the test.

You're missing the point: ORDER BY does not fix this, because the
problem is that the ordering is different in the locale you're using.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why must SELECT DISTINCT, ORDER BY expressions must appear in target list?
Next
From: Sean Chittenden
Date:
Subject: Re: PostgreSQL x Oracle