Problem with now() in function pgsql

From: "luke\(dot)78\(at)libero\(dot)it" <luke(dot)78(at)libero(dot)it>
To: "pgsql-sql" <pgsql-sql(at)postgresql(dot)org>
Subject: Problem with now() in function pgsql
Date: 2008-04-05 17:46:55
Message-ID: JYV5E7$EC8D8702500FEA2AF450CE088A16C723@libero.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2008-04-05 17:59:51 Re: Problem with now() in function pgsql
Previous Message chester c young 2008-04-04 01:53:03 Re: apparent RI bug