From: | James Cloos <cloos(at)jhcloos(dot)com> |
---|---|
To: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: defaults referencing other columns? |
Date: | 2006-09-04 03:41:35 |
Message-ID: | m3r6ys8fi1.fsf@lugabout.jhcloos.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
>>>>> "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
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2006-09-04 04:21:56 | Re: Progress and Questions |
Previous Message | James Cloos | 2006-09-04 03:38:34 | Re: function parameters |