"Jay" <jay.doo@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
