Re: < and > for datetime

Thanks.  Oops.  Now I see that I had one datetime and one date.

I can't do \do on my machine.  Many of the psql backslash commands
cause an error.  Does anyone know what could cause this error?  I am
running version 6.5.3 on an IRIX 6.5.
db=> \do
ERROR:  typeidTypeRelid: Invalid type - oid = 0

Thanks,

Sarah Officer
officers@aries.tucson.saic.com

Martin Schulze wrote:
>
> 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.