Re: WHERE (columnX IN (x,y,z)) ORDER BY columnY conflict

"Jay" <jay(dot)doo(at)gmail(dot)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