Default values?

From: "Bruce Richardson" <brichard@cafod.org.uk>

If I wanted to create a table in such a way that the default value of
one column is the value of another column (or the oid value), is there
a way to do that in the CREATE TABLE statement (with the DEFAULT
keyword, I'd imagine)? Or would I need to create a trigger?

--
Bruce

Trigger AFAIK. I've used functions in DEFAULTs but get errors with
references to another column. I presume it's because the system can't tell
whether your mean OLD.col or NEW.col

- Richard Huxton