Re: Use of 'now' - Mailing list pgsql-docs

From Thomas Lockhart
Subject Re: Use of 'now'
Date
Msg-id 3BF27B79.3F28F6D3@fourpalms.org
Whole thread Raw
In response to Re: Use of 'now'  (Vince Vielhaber <vev@michvhf.com>)
Responses Re: Use of 'now'
List pgsql-docs
...
> 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

pgsql-docs by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: Use of 'now'
Next
From: Bruce Momjian
Date:
Subject: Re: Use of 'now'