--- 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! Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
