Hi all, I propose to add an internal function gettime() that transparently returns the current system time, as a timestamptz with maximum precision.
Calling gettime() would be a more elegant approach than calling timeofday() and converting it to a timestamp, and avoids some of the potential problems in that conversion (such as "Sat" being misinterpreted as an Australian timezone). I'm open to alternate suggestions for the name of the function. If there are no objections, I'll start cooking up a patch right away. -- BJ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org