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(dot)dentella(at)mi(dot)infn(dot)it sandro(at)ermit(dot)it