Re: defaults referencing other columns?

>>>>> "RB" == Richard Broersma <rabroersma(at)yahoo(dot)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(at)jhcloos(dot)com> OpenPGP: 0xED7DAEA6