Re: User-defined types - Mailing list pgsql-general

From Tom Lane
Subject Re: User-defined types
Date
Msg-id 29787.1100718591@sss.pgh.pa.us
Whole thread Raw
In response to User-defined types  (Jonathan Daugherty <cygnus@cprogrammer.org>)
Responses Re: User-defined types
List pgsql-general
Jonathan Daugherty <cygnus@cprogrammer.org> writes:
> I'm trying to write a PL/PgSQL function whose sole parameter is an
> array whose element type is a type that I've created.  For example:

> According to the 7.4 docs,

>  "Whenever a user-defined base data type is created, PostgreSQL
>  automatically creates an associated array type, whose name consists
>  of the base type's name prepended with an underscore.

The key word in that sentence is "base" data type --- ie, not composite.
We don't currently support arrays of composite types.  (Nor arrays of
domain types, either, IIRC.)

            regards, tom lane

pgsql-general by date:

Previous
From: Jonathan Daugherty
Date:
Subject: User-defined types
Next
From: Jonathan Daugherty
Date:
Subject: Re: User-defined types