Re: [GENERAL] Nested tables - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: [GENERAL] Nested tables
Date
Msg-id Pine.LNX.4.21.0003040404490.489-100000@localhost.localdomain
Whole thread Raw
In response to Nested tables  (Jason Vasquez <VASQUEZ_JASON@Lilly.com>)
List 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@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-general by date:

Previous
From: Elmar.Haneke@gmx.de
Date:
Subject: Re: [GENERAL] database corruption?
Next
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] Median, Quartile and Percentile Aggregate Functions