Re: defaults referencing other columns? - Mailing list pgsql-novice

From James Cloos
Subject Re: defaults referencing other columns?
Date
Msg-id m3r6ys8fi1.fsf@lugabout.jhcloos.org
Whole thread Raw
In response to Re: defaults referencing other columns?  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-novice
>>>>> "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

pgsql-novice by date:

Previous
From: James Cloos
Date:
Subject: Re: function parameters
Next
From: John DeSoi
Date:
Subject: Re: Progress and Questions