Nick Johnson wrote:
Before I open a bug on this, I wanted to do a sanity check, since there
may be something I'm just not seeing.
I'm using PostgreSQL 8.2.3 and seeing this behaviour with timezones:
select create_date from article_lead;
create_date
---------------------------
2007-11-04 16:35:33.17+00
2007-11-04 04:35:36.09+00
2007-11-05 04:35:36.38+00
2007-11-05 16:35:36.67+00
(4 rows)
Note the top two are not in order (cuz you didnt 'order by create_date')
select create_date from article_lead where create_date >= '2007-11-03
17:00:00.0' and create_date <='2007-11-04 16:00:00.0';
create_date
---------------------------
2007-11-04 04:35:36.09+00
This one is correct, it is the second row. And the first row should not
be in because its > 16:00.
The db looks correct to me.
-Andy
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
