How can I create nested tables ?
I haven't find how it can be made in the doc.
Could someone give me a little example to create and then insert in
nested table?
Thank you.
Renaud THONNART
t;[EMAIL PROTECTED]> on 03/03/2000 06:32:19 PM
To: Jason Vasquez/AM/LLY@Lilly, [EMAIL PROTECTED]
cc:
bcc:
Subject: Re: [GENERAL] Nested tables
Ed Loehr wrote:
>
> Jason Vasquez wrote:
> > Basically, I'd like to set up an ACL-like property for each record. A
table
>
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 Pos
>Table ACL:
>Attribute |Type | Modifier
>---+-+
> uniqid| varchar(12) | not null
> date_created | timestamp | not null
> date_modified | timestamp | not null
> read | boolean | not null default
Ed Loehr wrote:
>
> Jason Vasquez wrote:
> > Basically, I'd like to set up an ACL-like property for each record. A table
> > could be strucured like this:
> >
> > Table ACL:
> >Attribute |Type | Modifier
> > ---+-+
> > un
Jason Vasquez wrote:
>
> I've looked through the documentation, but I've not found anything that
> addresses this situation. Is this possible with PostgreSQL? Or maybe there is
> a better way to accomplish what I want to do?
>
> Basically, I'd like to set up an ACL-like property for each record
I've looked through the documentation, but I've not found anything that
addresses this situation. Is this possible with PostgreSQL? Or maybe there is
a better way to accomplish what I want to do?
Basically, I'd like to set up an ACL-like property for each record. A table
could be strucured lik
On Fri, 24 Jul 1998, Ferruccio Zamuner wrote:
> CREATE TABLE foo (
> x int2
> );
>
> CREATE TABLE bar (
> y foo,
> z int
> );
>
> I read on some Postgres mailing digest that I had to put the OID of instance
> of foo into y field of bar.
>
> So I tried.
>
> The problem is that when I sub
