Now() in a function - Mailing list pgsql-sql

From sTesting
Subject Now() in a function
Date
Msg-id Sea1-DAV35ZvgK27nKz00012c5b@hotmail.com
Whole thread Raw
Responses Re: Now() in a function  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-sql
Hi,
 
I have a big problem, i wrote a very long function that is taking so much time. inside this function i added few debugging steps to find which section is taking most of the time, but all the created records have the same time in them, the time where the fuction begins.
I tried to different methods:
INSERT INTO f_error (error_id, creation_date)
VALUES (nextval(''s_f_error_id''), now());
 
INSERT INTO f_error (error_id, creation_date)
VALUES (nextval(''s_f_error_id''), ''now'');
 
Tanks in advance for your help.

pgsql-sql by date:

Previous
From: Jerome Alet
Date:
Subject: Re: avoid circular references
Next
From: Gaetano Mendola
Date:
Subject: Re: Now() in a function