From: | Erik Jones <erik(at)myemma(dot)com> |
---|---|
To: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
Cc: | Postgres General List <pgsql-general(at)postgresql(dot)org>, Kevin Hunter <hunteke(at)earlham(dot)edu>, Caktus Team <team(at)caktusgroup(dot)com> |
Subject: | Re: many to one of many modeling question |
Date: | 2008-01-08 03:28:26 |
Message-ID: | FDC4D0EC-6EF6-43A3-ADF3-6BD269B6F12F@myemma.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Jan 7, 2008, at 6:00 PM, Richard Broersma Jr wrote:
> --- On Mon, 1/7/08, Erik Jones <erik(at)myemma(dot)com> wrote:
>
>> From: Erik Jones <erik(at)myemma(dot)com>
>> Subject: Re: [GENERAL] many to one of many modeling question
>> To: "Richard Broersma Jr" <rabroersma(at)yahoo(dot)com>
>> Cc: "Postgres General List" <pgsql-general(at)postgresql(dot)org>, "Kevin
>> Hunter" <hunteke(at)earlham(dot)edu>, "Caktus Team" <team(at)caktusgroup(dot)com>
>> Date: Monday, January 7, 2008, 3:06 PM
>> On Jan 7, 2008, at 2:22 PM, Richard Broersma Jr wrote:
>>
>>> CREATE TABLE comments (
>>> id SERIAL,
>>> obj_id INTEGER ...
>>> FOREIGN KEY (obj_id)
>>> REFERENCES ONE OF o(id);
>>
>> Where are you guys getting this REFERENCES ONE OF stuff?
>
> Oops, my mistake. The OP was using this fake syntax "REFERENCES
> ONE OF" simply to illustrate the functionality that was desired. I
> forgot to delete this bad syntax from my example.
>
> Thanks for the correction!
No worries. I was actually serious in that I thought I may have
missed something!
Erik Jones
DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2008-01-08 04:49:23 | Re: Memory on 32bit machine |
Previous Message | Joshua D. Drake | 2008-01-08 02:49:00 | Re: Memory on 32bit machine |