>>>>> "RB" == Richard Broersma <rabroersma@yahoo.com> writes:
>> Can a default value reference the value specified for one of the
>> other columns in the insert?
RB> from:
RB> http://www.postgresql.org/docs/8.1/interactive/sql-createtable.html
RB> The value is any variable-free expression (subqueries and
RB> cross-references to other columns in the current table are not
RB> allowed).
[SIGH] I missed that part when reading thru the docs....
I read thru the whole tutorial section of the pdf, and I use \h
liberally in psql, but I didn't notice that point. ;-(
I'll find a different way to do it.
Thanks.
-JimC
--
James Cloos <cloos@jhcloos.com> OpenPGP: 0xED7DAEA6