Here is the test. I did not put it in mail because pine did not like
cut/paste. now I find a way to do it. It looks good!
the conclusion: current_timestamp is "current" -- it should be,
the looks closer than now/now() :-)
###############################################################
test3=> drop table account;
DROP
test3=> CREATE TABLE account (
test3-> act char(1) default 'Y',
test3-> createdfunc DATETIME DEFAULT now(),
test3-> createdcons DATETIME DEFAULT 'now',
test3-> created2cons DATETIME DEFAULT
'current_timestamp',
test3-> createdcurr DATETIME DEFAULT 'current'
test3-> );
CREATE
test3=>
test3=>
test3=> insert into account values('y');
INSERT 283346 1
test3=> insert into account values('1');
INSERT 283347 1
test3=> insert into account (createdcons) values(now());
INSERT 283348 1
test3=> insert into account (createdcons) values(now);
ERROR: Attribute now not found
test3=> insert into account (createdcons) values('now');
INSERT 283349 1
test3=> insert into account (createdcons) values(current);
ERROR: Attribute current not found
test3=> insert into account (createdcons) values('current');
INSERT 283350 1
test3=> insert into account (createdcons) values(current_timestamp);
INSERT 283351 1
test3=> insert into account (createdcons) values('current_timestamp');
INSERT 283352 1
test3=>
test3=> insert into account (createdcons) values(current_timestamp());
ERROR: parser: parse error at or near ")"
test3=> insert into account (createdcons) values(current_timestamp(now));
ERROR: parser: parse error at or near "now"
test3=> insert into account (createdcons) values(current_timestamp('now'));
ERROR: parser: parse error at or near "'"
test3=> insert into account (createdcons) values(now(current_timestamp));
ERROR: No such function 'now' with the specified attributes
test3=>
test3=> select * from account;
act|createdfunc |createdcons |created2cons|createdcurr
---+----------------------------+----------------------------+------------+-----------
y |Thu Dec 02 08:41:34 1999 CST|Thu Dec 02 08:41:33 1999 CST|current |current
1 |Thu Dec 02 08:41:34 1999 CST|Thu Dec 02 08:41:33 1999 CST|current |current
Y |Thu Dec 02 08:41:34 1999 CST|Thu Dec 02 08:41:34 1999 CST|current |current
Y |Thu Dec 02 08:41:34 1999 CST|Thu Dec 02 08:41:34 1999 CST|current |current
Y |Thu Dec 02 08:41:34 1999 CST|current |current |current
Y |Thu Dec 02 08:41:34 1999 CST|Thu Dec 02 08:41:34 1999 CST|current |current
Y |Thu Dec 02 08:41:34 1999 CST|current |current |current
(7 rows)
test3=> select * from account where createdcons = 'now';
act|createdfunc |createdcons |created2cons|createdcurr
---+----------------------------+----------------------------+------------+-----------
Y |Thu Dec 02 08:41:34 1999 CST|Thu Dec 02 08:41:34 1999 CST|current |current
Y |Thu Dec 02 08:41:34 1999 CST|Thu Dec 02 08:41:34 1999 CST|current |current
Y |Thu Dec 02 08:41:34 1999 CST|current |current |current
Y |Thu Dec 02 08:41:34 1999 CST|Thu Dec 02 08:41:34 1999 CST|current |current
Y |Thu Dec 02 08:41:34 1999 CST|current |current |current
(5 rows)
test3=> select * from account where createdcons = now();
act|createdfunc |createdcons |created2cons|createdcurr
---+----------------------------+----------------------------+------------+-----------
Y |Thu Dec 02 08:41:34 1999 CST|Thu Dec 02 08:41:34 1999 CST|current |current
Y |Thu Dec 02 08:41:34 1999 CST|Thu Dec 02 08:41:34 1999 CST|current |current
Y |Thu Dec 02 08:41:34 1999 CST|current |current |current
Y |Thu Dec 02 08:41:34 1999 CST|Thu Dec 02 08:41:34 1999 CST|current |current
Y |Thu Dec 02 08:41:34 1999 CST|current |current |current
(5 rows)
test3=> select * from account where createdcons = 'current';
act|createdfunc |createdcons |created2cons|createdcurr
---+----------------------------+----------------------------+------------+-----------
Y |Thu Dec 02 08:41:34 1999 CST|Thu Dec 02 08:41:34 1999 CST|current |current
Y |Thu Dec 02 08:41:34 1999 CST|Thu Dec 02 08:41:34 1999 CST|current |current
Y |Thu Dec 02 08:41:34 1999 CST|current |current |current
Y |Thu Dec 02 08:41:34 1999 CST|Thu Dec 02 08:41:34 1999 CST|current |current
Y |Thu Dec 02 08:41:34 1999 CST|current |current |current
(5 rows)
test3=> select * from account where createdcons = 'current_timestamp';
act|createdfunc |createdcons|created2cons|createdcurr
---+----------------------------+-----------+------------+-----------
Y |Thu Dec 02 08:41:34 1999 CST|current |current |current
Y |Thu Dec 02 08:41:34 1999 CST|current |current |current
(2 rows)
test3=> select * from account where createdcons = current_timestamp();
ERROR: parser: parse error at or near ")"
test3=> select * from account where createdcons = current_timestamp('now');
ERROR: parser: parse error at or near "'"
test3=> select * from account where createdcons = 'current_timestamp('now')';
ERROR: parser: parse error at or near "now"
##############################################################
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
>
> ************
>
************
