Re: time stops within transaction

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Alex Pilosov <alex(at)pilosoft(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: time stops within transaction
Date: 2000-10-18 08:38:01
Message-ID: Pine.LNX.3.96.1001018103431.26506C-100000@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 17 Oct 2000, Alex Pilosov wrote:

> I just ran into a strangest thing: within transaction, select now() will
> always return time when transaction started. Same happens with select
> 'now'::timestamp.

It's feature, not bug. IMHO good feature, an example I use it for rows
identification during table filling :-)

Karel

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB 2000-10-18 08:38:09 AW: AW: Backup, restore & pg_dump
Previous Message Ronald Kuczek 2000-10-18 06:34:25 AW: UPPER and LOWER dosen't work correctly on special caracters (umlauts)