"zagman" <[EMAIL PROTECTED]> writes:
> I'm setting up a simple timecard program and I need a column that
> defaults to the current time when a new row is inserted. How can I do
> this I tried setting the default to 'now' but all that does is put the
> time I created the table in each row!
The default has to be a function call, not a literal constant, to work
the way you want. Try
mycol timestamp default now()
or
mycol timestamp default current_timestamp
(the latter is actually a function call, even though the SQL standard
says it has to be spelled without any parentheses)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
