Re: Create type

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>