Re: Date Interval

Magdalena Komorowska wrote:
> 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

How about this?
test=> CREATE TABLE test(x TEXT);CREATE TABLEtest=> INSERT INTO test VALUES ('3');INSERT 0 1test=> SELECT
current_timestamp+ cast(x || ' months' AS INTERVAL) FROMtest;           ?column?-------------------------------
2006-03-0611:53:05.574279-05(1 row)
 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073