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