Postgres Pro
Downloads
Home   >   mailing lists

Thread: Now() in a function

Now() in a function

From
"sTesting"
Date:
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.

Re: Now() in a function

From
Gaetano Mendola
Date:
sTesting wrote:

> 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'');

now() give you the time when the transaction started,
so what you see is the intended behavior, in your case you must use:
timeofday().


Regards
Gaetano Mendola