plpgsql & date-time functions - Mailing list pgsql-sql

From Fatih Cerit
Subject plpgsql & date-time functions
Date
Msg-id d0k4vn$1dmm$1@news.hub.org
Whole thread Raw
Responses Re: plpgsql & date-time functions  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-sql
I have a function and I want to update a table's two rows but having problem 
with plpgsql & date-time functions. First field of the table must be now() 
this is ok.. but the second field must be now() + '60 days' if the query 
like this : SELECT INTO to_day now() + interval '60 days' ; it works but if 
I use variable instead of  '60 days' it doesn't work. And I must use 
variable....

Thanks




pgsql-sql by date:

Previous
From: "Igor Kryltsov"
Date:
Subject: Re: Update PostgreSQL from MS SQL trigger
Next
From: "Sim Zacks"
Date:
Subject: Re: group by before and after date