Date Interval - Mailing list pgsql-sql

From Magdalena Komorowska
Subject Date Interval
Date
Msg-id 20051206135906.ECA9713E35@spinet.pl
Whole thread Raw
Responses Re: Date Interval
Re: Date Interval
List pgsql-sql
Hi,
I hale a problem with counting interwal and I can't find what to do with
this. 
I have two fields in the table:   Column       |  Type   | Modifiers
-----------------+---------+-----------date_in         | date    |interwal_months | numeric |
-----------------+---------+-----------

Query
SELECT date_in + INTERVAL '3 MONTH' FROM any_table
works fine of course. 

However, how to do something like that?
SELECT date_in + INTERVAL ' interwal_months MONTH' FROM any_table

I hope I'm just blind.. ;-)
Thanks for any help.
MK




pgsql-sql by date:

Previous
From: Luca Pireddu
Date:
Subject: Re: [GENERAL] lost in system tables
Next
From: Bruce Momjian
Date:
Subject: Re: Date Interval