Re: [GENERAL] Date & Time

> I agree. my fault. sql92 constant is "global", it should not be in single
> quotation mark, while pg's "now" is datetime's constant, it should be in
> single quotation mark.
>
> seems we do not need now/now() anymore!!!
>
> seems that the problem/feature is the "current" implementation: it only
> compare the beginning of the word. interesting!
>

Ah, but look at this under current tree:

test=> create table kk (x datetime default current_timestamp);
CREATE
test=> \d kk
                           Table "kk"
 Attribute |   Type   |                  Extra
-----------+----------+------------------------------------------
 x         | datetime | default timestamp(datetime('now'::text))

Internally, it is using 'now'.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026