Re: BUG #2387: Incorrect sorting of timestamp with time zone

"" <christian.koth@smiths-heimann.com> writes:
> SELECT time_stamp, time_stamp_with_zone from timetest order by
> time_stamp_with_zone;

> I get the following result:
>      time_stamp      |  time_stamp_with_zone
> ---------------------+------------------------
>  2006-09-23 20:01:00 | 2006-09-23 23:01:00+00
>  2006-09-23 22:01:00 | 2006-09-24 00:01:00+00
>  2006-09-23 21:01:00 | 2006-09-24 00:01:00+00
>  2006-09-23 23:01:00 | 2006-09-24 01:01:00+00
>  2006-09-24 00:01:00 | 2006-09-24 02:01:00+00

> As one can see lines 2 and 3 are in the wrong order.

AFAICS, they are the same value, so they can be sorted in either order.
Which way they'll end up depends on undocumented properties of your
platform's qsort() routine.

            regards, tom lane