no, you won't ;-)
further testing indicates that current_stamp like current, instead of
now/now().
also, I remembered (I tried to check the archive, but failed) now() should
not be use in where clause, cos it will hurt performance.
Kai
On Wed, 1 Dec 1999, Bruce Momjian wrote:
> > Ed Loehr ha scritto:
> >
> > > Just curious: anyone have any comment on any practical differences between
>now() and CURRENT_TIMESTAMP, which seems to work
> > > the same?
> > >
> >
> > I think it is the same function, both of them return the current date and time.
> >
> > now() should be the internal postgreSQL function.
> > and CURRENT_TIMESTAMP is the exact SQL-92 syntax
>
> I am changing my book to use CURRENT_TIMESTAMP rather than now().
>
> --
> Bruce Momjian | http://www.op.net/~candle
> [EMAIL PROTECTED] | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>
> ************
>
************
