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

From Jay
Subject WHERE (columnX IN (x,y,z)) ORDER BY columnY conflict
Date
Msg-id 064f230e-e051-4262-a632-0ffb7356b503@d27g2000prf.googlegroups.com
Whole thread Raw
Responses Re: WHERE (columnX IN (x,y,z)) ORDER BY columnY conflict
List pgsql-general
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...

Thanks,

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re #1: top posting (was: Hijack!)
Next
From: "A. Ozen Akyurek"
Date:
Subject: copy a large table raises out of memory exception