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 [EMAIL PROTECTED] ************