Re: [GENERAL] Date & Time

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
>
> ************
>