Re: [SQL] Problem with now() in function pgsql

2008-04-05 Thread Adrian Klaver
On Saturday 05 April 2008 10:46 am, [EMAIL PROTECTED] wrote: > 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...

[SQL] Problem with now() in function pgsql

2008-04-05 Thread [EMAIL PROTECTED]
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