Search Postgresql Archives

Re: many to one of many modeling question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux