Problems with UNION ALL and ORDER BY

From: Kaloyan Iliev Iliev <news1(at)faith(dot)digsys(dot)bg>
To: pgsql-sql(at)postgresql(dot)org
Subject: Problems with UNION ALL and ORDER BY
Date: 2004-08-02 17:37:15
Message-ID: 410E7BCB.9020604@faith.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

10x for the replies.
We find the problem. It is in our scripts.
We use to_char over a date field and then order by this field. So it sort it as text and not as date.
I appologize for loosing your time.
10x again.

Browse pgsql-sql by date

  From Date Subject
Next Message Kris Jurka 2004-08-02 17:44:24 Re: org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143)
Previous Message Tom Lane 2004-08-02 17:09:42 Re: Problems with UNION ALL and ORDER BY