Forum OpenACS Development: current_timestamp = ('now'::text)::timestamp(6) with time zone
I'm looking at how postgres stores default values for table definitions, and for acs_objects, and probably a lot of other places, the default of now() has been replaced with current_timestamp in the table def. But when you look in the pg_ tables, this is stored as ('now'::text)::timestamp(6) with time zone. Selecting any of these three from psql gives the same result. So is current_timestamp a keyword like table, create, etc? Why was the change made from now() to current_timestamp?
You might even be interested in this thread: https://openacs.org/forums/message-view?message_id=111063
Oracle 9i, at least, also has the timestamp stuff from SQL 92 and eventually I'm hopeful we can use the standard syntax for both RDBMSs (even if other differences mean we can't truly share table definition code, drat)