Postgres Pro
Downloads
Home   >   mailing lists

Re: Is now() atomic? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Is now() atomic?
Date
Msg-id 13317.1197563850@sss.pgh.pa.us
Whole thread Raw
In response to Is now() atomic?  (Michael Lush <mjlush@ebi.ac.uk>)
List pgsql-novice
Tree view 
Michael Lush <mjlush@ebi.ac.uk> writes:
> Does now() record the time that the SELECT statement was executed
> or the time that the row is printed out?

http://www.postgresql.org/docs/8.2/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

            regards, tom lane

pgsql-novice by date:

Previous
From: Michael Lush
Date:
Subject: Is now() atomic?
Next
From: Mark Wimer
Date:
Subject: Re: SQL Query