From: | "Richard Huxton" <dev(at)archonet(dot)com> |
---|---|
To: | "Renaud Tthonnart" <thonnart(at)amwdb(dot)u-strasbg(dot)fr>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Create type |
Date: | 2001-02-27 09:30:15 |
Message-ID: | 003801c0a09f$e8272e60$1001a8c0@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
From: "Renaud Tthonnart" <thonnart(at)amwdb(dot)u-strasbg(dot)fr>
> If I can't use nested tables, how can I create a
> type that will be a kind of "dynamic list of structure".
>
> regards,
> Renaud THONNART
>
> 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.
>
> Thank you for your help.
> Renaud THONNART
Ah - you can define your own types using C and then should be able to have
an array of them. Never done this myself, but the relevant information is in
the Programmer's Guide - 13. Extending SQL: Types
You will probably end up building supporting functions and operators for the
type too.
- Richard Huxton
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Livesey | 2001-02-27 09:44:04 | Slowdown problem when writing 1.7million records |
Previous Message | Jose Manuel Lorenzo Lopez | 2001-02-27 09:28:36 | Re: Help with pq++ |