Re: Custom types and arrays

mlunnon @ RWA wrote:
> Thanks for your reply tom. I'm sure it is not a mistype, I included the
> definition that I used in my script. Perhaps it is something to do with the
> cygwin installation of Postgres that I have i will try it on a Linux box.
>

The type you were referring to is a composite type:
   CREATE TYPE TEST_TYPE AS (ID INTEGER, CODE VARCHAR(40));

The documentation wording could be improved (perhaps it should say
"user-defined *base* types?), but there is no support for arrays of
composite types -- or at least if there is, I've never seen it. I know
for sure that creation of a user defined composite type will not create
a corresponding array type.

Joe