Tom Lane writes:
Trymycol 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)
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? I know Postgresql has timeofday(), but it's not standard (plus it's weird that it returns a text string).
- John D. Burger MITRE ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
