On 2012-01-26, David W Noon <dwnoon@xxxxxxxxxxxx> wrote: > > Try using CURRENT_TIMESTAMP instead. In fact, CURRENT_TIMESTAMP is > more traditional SQL than now(). I don't have an ANSI standard handy, > so I cannot be certain when now() was added, if ever; but I have been > using CURRENT TIMESTAMP (space instead of vinculum) under DB2 for 20 > years or more. The planner will rewrite CURRENT_TIMESTAMP to now() :) -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
