Re: CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP

You may be right that sometime is not that easy to fin documentation, but to
see how CURRENT_TIME works, try:

erm=> select CURRENT_DATE;
  ?column?
----------
29-02-2000
(1 row

I use it (and the others) in default part of create table:
create table aaa (
   who  text  DEFAULT CURRENT_USER,
   when date  NOT NULL DEFALUT CURRENT_DATE
);

The problem is pg_dump transforms CURRENT_DATE in something w/ "'" that can
not be fed back to    "psql db < file"

By
sandro
*:-)

--
Sandro Dentella  *:-)
e-mail: sandro.dentella@mi.infn.it sandro@ermit.it