Subtracting from a date - Mailing list pgsql-sql

From Andrew Perrin - Demography
Subject Subtracting from a date
Date
Msg-id Pine.LNX.4.10.10004121040080.12210-100000@famine.DEMOG.Berkeley.EDU
Whole thread Raw
List pgsql-sql
I need to find all records with a date field (date_effective) 3 years or
less prior to now().  This clearly must be possible, but I'm not figuring
it out.  Any suggestions?

---------------------------------------------------------------------
Andrew J. Perrin - aperrin@demog.berkeley.edu - NT/Unix Admin/Support
Department of Demography    -    University of California at Berkeley
2232 Piedmont Avenue #2120  -    Berkeley, California, 94720-2120 USA
http://demog.berkeley.edu/~aperrin --------------------------SEIU1199



pgsql-sql by date:

Previous
From: "Alex Verstak"
Date:
Subject: UNION support for rules
Next
From: Tom Lane
Date:
Subject: Re: UNION support for rules