Re: [SQL] plpgsql & date-time functions

[Stephan Szabo]

On Tue, 8 Mar 2005, Fatih Cerit wrote:

> 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

If you want a variable number of days, something like
 now() + variable * interval '1 day'
will probably work.


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

[SQL] plpgsql & date-time functions

[Fatih Cerit]

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



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])