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"