plpgsql & date-time functions

From: "Fatih Cerit" <fatih(at)intersan(dot)com(dot)tr>
To: pgsql-sql(at)postgresql(dot)org
Subject: plpgsql & date-time functions
Date: 2005-03-08 12:14:47
Message-ID: d0k4vn$1dmm$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2005-03-08 12:17:03 Re: Query issue/8.0.1/Serendipity
Previous Message Larry Rosenman 2005-03-08 11:48:16 Query issue/8.0.1/Serendipity