Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by postgresql.org (Postfix) with SMTP id 881E1475452 for ; Thu, 18 Apr 2002 08:04:34 -0400 (EDT) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Thu Apr 18 14:04:36 2002 +0200 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id OAA26096 for ; Thu, 18 Apr 2002 14:04:36 +0200 (METDST) From: Christoph Haller Message-Id: <200204181204.OAA11703@rodos> Subject: now() does not change within a transaction To: pgsql-sql@postgresql.org Date: Thu, 18 Apr 2002 14:04:35 METDST X-Mailer: Elm [revision: 212.4] X-Archive-Number: 200204/219 X-Sequence-Number: 7483 Hi pgsql-sql list, I did some testing around tables using a column timestamp with time zone not null default now(). I have noticed a valuable feature: As long as being inside a transaction initiated by begin; the return value of the now() function does not change. Is this intended - as written in the documentation? Can I rely on it, so future releases of PostgreSQL will act the same. Regards, Christoph