Olivier Hubaut <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> This does not work anymore in PG 7.4. You need something like
>> datumi date DEFAULT CURRENT_DATE,
> I think the now()::date seems to be a better way to translate the
> 'today' value.
There is no real difference.
Olivier Hubaut wrote:
> 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.
Your knowledge is incorrect.
---(end of broadcast)---
TIP 8: explain anal
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 lik
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
