From: | Brian McCane <bmccane(at)mccons(dot)net> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | ALTER TABLE ... SET DEFAULT |
Date: | 2002-04-12 07:02:29 |
Message-ID: | 20020412015602.S18686-100000@fw.mccons.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I have a field called 'updated' of type 'integer' in a table. I have
created a function called 'since_epoch' which is declared with iscacheable
and returns the value of 'extract(epoch from now())'. I want to make
'updated' have a default of 'since_epoch()'. I cannot get it to work with
the following command:
alter table foo alter column updated set default 'since_epoch()' ;
this gets the error:
ERROR: pg_atoi: error in "since_epoch()": can't parse "since_epoch()"
I tried using 'since_epoch()::integer', but that failed as well.
Is it possible to make the default value of an integer field use a
function similar to how we use 'now()' for date and timestamp fields?
- brian
Wm. Brian McCane | Life is full of doors that won't open
Search http://recall.maxbaud.net/ | when you knock, equally spaced amid those
Usenet http://freenews.maxbaud.net/ | that open when you don't want them to.
Auction http://www.sellit-here.com/ | - Roger Zelazny "Blood of Amber"
From | Date | Subject | |
---|---|---|---|
Next Message | Brian McCane | 2002-04-12 07:21:07 | Re: ALTER TABLE ... SET DEFAULT |
Previous Message | Tom Lane | 2002-04-11 22:02:23 | Re: More question about plans & explain (long) |