"John D. Burger" <[EMAIL PROTECTED]> writes:
>> mycol timestamp default now()
>> or
>> mycol timestamp default current_timestamp
> And both of these return start time of the current transaction, yes?
> Is it the case that there is no SQL-standard way to get the current
> time?
AFAIK the spec doesn't really define the meaning of current_timestamp
all that closely. I believe there's a patch in the queue to add some
additional nonstandard functions for current time and start of current
interactive command, though.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
