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

From: Jay <jay(dot)doo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: WHERE (columnX IN (x,y,z)) ORDER BY columnY conflict
Date: 2007-12-11 17:01:49
Message-ID: 064f230e-e051-4262-a632-0ffb7356b503@d27g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2007-12-11 17:02:04 Re: if exists...does it exists for insert statments?
Previous Message Joshua D. Drake 2007-12-11 17:01:46 Re: psql batch file question