Well that was easy enough... Thanks!
Michael Fuhr <[EMAIL PROTECTED]> wrote: On Mon, Aug 13, 2007 at 07:16:30AM
-0700, Jeff Lanzarotta wrote:
> select * from foobar where ts between now() and now() - interval '5 days'
>
> btw, the column ts is defined as:
>
> ts timestamp with time zone NOT NUL
On Mon, Aug 13, 2007 at 07:16:30AM -0700, Jeff Lanzarotta wrote:
> select * from foobar where ts between now() and now() - interval '5 days'
>
> btw, the column ts is defined as:
>
> ts timestamp with time zone NOT NULL DEFAULT now()
>
> No rows are returned, but I know there are at least 100 ro