Re: < and > for datetime

Sarah Officer wrote:
> Hi all,
>
> I'm trying to find  less than and greater than functions for
> datetime types.  It doesn't look the the time interval operators
> would be appropriate, but I haven't found anything else in the
> docs.  Here's my snippet of plpgsql which fails:
>
>     select count(*) into rescount
>     from currentresults cr, masters m
>     where cr.ben = new.ben
>     and m.mi_id = cr.mi_id
>     and m.idate > mydate;
>
> rescount & mydate are variables.  How do I compare dates?  I'd be
> glad to read the documentation if I could find the right page.

\do shows:

<= |datetime  |datetime  |bool     |less-than-or-equal
<> |datetime  |datetime  |bool     |not equal
=  |datetime  |datetime  |bool     |equal
>  |datetime  |datetime  |bool     |greater-than
<  |datetime  |datetime  |bool     |less-than

Thus, your WHERE-clause should be proper.

Regards,

    Joey

--
This is Linux Country.  On a quiet night, you can hear Windows reboot.