Problem with now() in function pgsql - Mailing list pgsql-sql

From luke\.78\@libero\.it
Subject Problem with now() in function pgsql
Date
Msg-id JYV5E7$EC8D8702500FEA2AF450CE088A16C723@libero.it
Whole thread Raw
Responses Re: Problem with now() in function pgsql  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-sql
Hi,
I have a problem in a function pgsql with Reading TIMESTAMP calling the function now()
the problem is this:
At the begin of function I read timestamp...
select now() into TS_BEGIN;

the function execute some statement...

Many seconds after I reread the timestamp
select now() into TS_END;

and TS_BEGIN is identical TS_END!!!

Can anyone help me?

Thanks in advance.

Luke.



pgsql-sql by date:

Previous
From: chester c young
Date:
Subject: Re: apparent RI bug
Next
From: Adrian Klaver
Date:
Subject: Re: Problem with now() in function pgsql