From: luke\.78\@libero\.it <luke.78@libero.it>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Problem with now() in function pgsql
Date: Sat, 5 Apr 2008 19:46:55 +0200
Message-ID: <JYV5E7$EC8D8702500FEA2AF450CE088A16C723@libero.it> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: luke.78@libero.it
Subject: Re: Problem with now() in function pgsql
In-Reply-To: <JYV5E7$EC8D8702500FEA2AF450CE088A16C723@libero.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox