Re: [SQL] dump and schema

[Olivier Hubaut]

Tom Lane wrote:

van Elsacker Frans <[EMAIL PROTECTED]> writes:

All my tables (more than 100) have a field datumi of type date default 
today, as this example:
CREATE TABLE tabel (
    ....
    datumi date DEFAULT 'today',
    ....
);


This does not work anymore in PG 7.4.  You need something like

	datumi date DEFAULT CURRENT_DATE,

			regards, tom lane

I think this won't get the same result he expects. As I know, the 
CURRENT_DATE will always give the current day, not the day you inserted 
the row.

I think the now()::date seems to be a better way to translate the 
'today' value.

--
Ci-git une signature avortee.
** RIP **
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]