Re: many to one of many modeling question

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