On Tue, Feb 27, 2001 at 09:11:43AM +0100, Renaud Tthonnart wrote:
> Richard Huxton wrote:
> >
> > Sorry Renaud, I'm not sure it's clear what you're trying to do.
> > Could you post an example of what you're trying to achieve to the
> > list? That'd probably help
>
> Ok. First I wanted to use nested tables. But I think it is not
> possible.
>
> Then I decided to create a type that will made the same function, a
> type that will be like a C structure. This type would contain an
> integer and a string like (1,'aaa'). Then I would have made a list or
>
> an array with this type. Am I clear? Sorry if not, my English is
> poor.
I think the original question still stands. What are you trying do?
Can't you map your "structure" to a regular table? A list of struct's
containing one integer and one string sounds like a table containing
one integer and one string (with the possible addition of an extra
key field if the integer is not already an identifier).
CREATE TABLE list_struct (
i integer NOT NULL,
c varchar(255) NOT NULL
CHECK (char_length(c) > 0),
PRIMARY KEY (i, c)
);
--
Eric G. Miller <egm2@jps.net>