"Ken Winter" <[EMAIL PROTECTED]> writes: > How can a column's default be set to 'now', meaning 'now' as of when each > row is inserted?
You need a function, not a literal constant. The SQL-spec way is CURRENT_TIMESTAMP (which is a function, despite the spec's weird idea that it should be spelled without parentheses); the traditional Postgres way is now() Either way only sets an insertion default, though. If you want to enforce a correct value on insertion, or change the value when the row is UPDATEd, you need to use a trigger. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org