On Jan 7, 2008, at 6:00 PM, Richard Broersma Jr wrote:
--- On Mon, 1/7/08, Erik Jones <erik@xxxxxxxxxx> wrote:
From: Erik Jones <erik@xxxxxxxxxx>
Subject: Re: many to one of many modeling question
To: "Richard Broersma Jr" <rabroersma@xxxxxxxxx>
Cc: "Postgres General List" <pgsql-general@xxxxxxxxxxxxxx>, "Kevin
Hunter" <hunteke@xxxxxxxxxxx>, "Caktus Team" <team@xxxxxxxxxxxxxxx>
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@xxxxxxxxxx
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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/