Search Postgresql Archives

Re: User-defined types

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jonathan Daugherty <cygnus@xxxxxxxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux