< and > for datetime - Mailing list pgsql-general

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.

Thanks,

Sarah
officers@aries.tucson.saic.com