> 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