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