Haven't tried yet, but perhaps casting nummonths to an interval datatype 
would do the trick.

-r

At 04:30 PM 9/26/01 -0400, Vince Vielhaber wrote:


>I'm trying to use an integer from a table to add/subtract time in months.
>IOW:
>
>create table foo(nummonths int);
>
>select now() - nummonths months;
>
>So far nothing I've tried will work - short of a function.  Is there a
>way to do this?
>
>Vince.
>--
>==========================================================================
>Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
>          56K Nationwide Dialup from $16.00/mo at Pop4 Networking
>         Online Campground Directory    http://www.camping-usa.com
>        Online Giftshop Superstore    http://www.cloudninegifts.com
>==========================================================================
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
Wed, 26 Sep 2001 17:14:19 -0400
Ryan Mahoney <ryan@paymentalliance.net>
Re: casting for dates