Michael Fuhr <mike@fuhr.org> writes:
> On Wed, Oct 12, 2005 at 08:23:15PM +0100, Oliver Elphick wrote:
>> I actually use CURRENT_DATE; that is what the system turns it into.
> Ah yes, I see that now. I generally use now(), so I hadn't noticed
> that CURRENT_DATE and CURRENT_TIMESTAMP become 'now', whereas only
> a literal 'now' is expanded at create time:
Yeah. That implementation of CURRENT_TIMESTAMP and friends is
historical, and probably ought to be changed sometime. It works OK
but it's ugly, especially for reverse-listing purposes.
regards, tom lane