Re: [HACKERS] adate::Date is equiv. to adate if adate is type of Date ?

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] adate::Date is equiv. to adate if adate is type of Date ?
Date: 1999-05-04 02:06:04
Message-ID: 372E560C.3D34AB5D@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> btw, how I can find 'something' older than a month, i.e.
> select * from titles
> where adate::date > 'today'::Date - '1 month'::timespan;

select * from titles
where adate::date < 'today'::Date - '1 month'::timespan;

??

- Tom

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Todd Graham Lewis 1999-05-04 02:32:49 Re: [HACKERS] XIDTAG ???
Previous Message Tom Lane 1999-05-04 00:21:41 Re: [HACKERS] an older problem? hash table out of memory