From: Thomas Lockhart <lockhart@fourpalms.org>
To: Vince Vielhaber <vev@michvhf.com>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Subject: Re: Use of 'now'
Date: Wed, 14 Nov 2001 14:11:05 +0000
Message-ID: <3BF27B79.3F28F6D3@fourpalms.org> (raw)
References: <Pine.BSF.4.40.0111140553380.84965-100000@paprika.michvhf.com>
...
> template1=# insert into dd (y) values (1);
> template1=# select * from dd;
> x | y
> ---------+---
> current | 1
> Must be since 7.0.3?
Prior to 7.2 (and up to two months ago -- ?? haven't checked the dates)
'current' was stored as a special value. It was only evaluated as the
current transaction time when math or some other transformation was
involved.
The feature dates from sometime after 1987 and sometime before 1995
(back when gods roamed the earth, etc etc).
Regarding the TIME data type: there was never a reserved value defined
for that type, so the feature was never available for it. Since
'current' and 'now' are synonymous, it is a one-liner to add recognition
of 'current' to that type. I've got patches...
- Thomas
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-docs@postgresql.org
Cc: lockhart@fourpalms.org, vev@michvhf.com, pgman@candle.pha.pa.us, tgl@sss.pgh.pa.us
Subject: Re: Use of 'now'
In-Reply-To: <3BF27B79.3F28F6D3@fourpalms.org>
* 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