Problems with UNION ALL and ORDER BY

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.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo [at] postgresql.org)
news1 [ Mo, 02 August 2004 19:37 ] [ ID #453152 ]
Datenbanken » comp.databases.postgresql.sql » Problems with UNION ALL and ORDER BY

Vorheriges Thema: org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143)
Nächstes Thema: Problems with UNION ALL and ORDER BY