in ""current" implementation", I mean the implementation of "current". OK,
my fault again. I'm beaten :-) thanks
for 6.5.1 that I'm using, it is: "datetime default now()"
> > 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
>
> ************
>
