Tom Lane wrote:
> van Elsacker Frans <fve@atbib.be> 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 **