"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