Brian Hirt <[EMAIL PROTECTED]> writes:
> select count(*) from redir_log
> where redir_timestamp >= '10/14/2004'::timestamp without time zone at time
> zone 'GMT';
That seems like the hard way to express a timestamp constant. Why not
select count(*) from redir_log
where redir_timestamp >= '10/14/2004 00:00 GMT';
(FWIW, though, the AT TIME ZONE construct *should* have been collapsed
to a constant; 8.0 fixes this.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
