Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Nested tables

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Jason Vasquez <VASQUEZ_JASON(at)Lilly(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Nested tables
Date: 2000-03-04 17:05:49
Message-ID: Pine.LNX.4.21.0003040404490.489-100000@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-general
Jason Vasquez writes:

> PostgreSQL lets me create the class myItem with a "acl" field type, but I
> can't figure out how to insert multiple values (or any values!) into the
> access_control field...

This seems to be a remnant of the highly praised "object-relational"
features once present in Postgres but now fallen to neglect and poorly
understood. You probably don't want to do this but use a foreign key
instead.

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e(at)gmx(dot)net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


In response to

pgsql-general by date

Next:From: Jason VasquezDate: 2000-03-04 17:28:30
Subject: Re: [GENERAL] Nested tables
Previous:From: Peter EisentrautDate: 2000-03-04 17:05:29
Subject: Re: [GENERAL] Illegal use of aggregates or non-group column in target list

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group