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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026