Re: interval +variable - Mailing list pgsql-sql

From ALÝ ÇELÝK
Subject Re: interval +variable
Date
Msg-id d0p449$1mae$1@news.hub.org
Whole thread Raw
In response to interval +variable  ("Fatih Cerit" <fatih@intersan.com.tr>)
List pgsql-sql
+ '1 days'::interval

""Fatih Cerit"" <fatih@intersan.com.tr>, haber iletisinde �unlar� 
yazd�:008a01c52486$1c1c9520$bb41ccd5@cerit...
> Dear all
>
> Is there anyone at there who knows howto use dateadd in pgsql. I have a 
> problem in my function that is like this ;
>
> Select into futuredate now() + interval '30 days';  <- this is ok
> but how can I use a variable intead of '30 days'    :(
>
> Thanks
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match
> 




pgsql-sql by date:

Previous
From: Stef
Date:
Subject: Re: [SOLVED] Postgres schema comparison.
Next
From: Henry Ortega
Date:
Subject: best way to auto-update a field when row is updated