Postgres Pro
Downloads
Home   >   mailing lists

Problems with UNION ALL and ORDER BY - Mailing list pgsql-sql

From Kaloyan Iliev Iliev
Subject Problems with UNION ALL and ORDER BY
Date
Msg-id 410E7BCB.9020604@faith.digsys.bg
Whole thread Raw
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with UNION ALL and ORDER BY
Next
From: Kris Jurka
Date:
Subject: Re: org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143)