Re: [GENERAL] What is the syntax for setting a default date in PostgreSQL

2006-02-20 Thread Andreas Kretschmer
[EMAIL PROTECTED] <[EMAIL PROTECTED]> schrieb: > > > This issue always stumps me. I need to set the default date for a column in > postgres. A value for today, today + x days, now (timestamp), now + x amount > of > days. test=# select current_date; date 2006-02-20 (1 row) te

[GENERAL] What is the syntax for setting a default date in PostgreSQL

2006-02-20 Thread lists
This issue always stumps me. I need to set the default date for a column in postgres. A value for today, today + x days, now (timestamp), now + x amount of days. I never seem to be able to locate it in the documentation or online. Can anyone post it here once and for all for posterity? I will b

Re: [GENERAL] What is the syntax for setting a default date in PostgreSQL?

2006-02-20 Thread Alban Hertroys
Frank Church wrote: This issue always stumps me. I need to set the default date for a column in postgres. A value for today, today + x days, now (timestamp), now + x amount of days. CURRENT_DATE, CURRENT_DATE + x, now(), now() + 'x days'::interval are a few options. -- Alban Hertroys [EMAIL

[GENERAL] What is the syntax for setting a default date in PostgreSQL?

2006-02-20 Thread Frank Church
This issue always stumps me. I need to set the default date for a column in postgres. A value for today, today + x days, now (timestamp), now + x amount of days. I never seem to be able to locate it in the documentation or online. Can anyone post it here once and for all for posterity? I will be