Re: WHERE (columnX IN (x,y,z)) ORDER BY columnY conflict - Mailing list pgsql-general

From Gregory Stark
Subject Re: WHERE (columnX IN (x,y,z)) ORDER BY columnY conflict
Date
Msg-id 874pen4yq8.fsf@oxford.xeocode.com
Whole thread Raw
In response to WHERE (columnX IN (x,y,z)) ORDER BY columnY conflict  (Jay <jay.doo@gmail.com>)
List pgsql-general
"Jay" <jay.doo@gmail.com> writes:

> I've been trying to get this query to work to no avail. Both parts
> work in isolation. I am able to replace the IN clause with an ILIKE
> statement and the ORDER BY works fine. But in combination with the IN
> statement, the ORDER BY statement does not actually order the results,
> though no errors are thrown and the IN section returns results as
> expected.  Am I missing something simple here? I haven't been able to
> turn up any results on google...

Post an example of what you're talking about.

Also, what version of the server are you using?
Have you updated to the latest bug-fix release for that version?

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Slow PITR restore
Next
From: Simon Riggs
Date:
Subject: Re: Slow PITR restore