Re: User-defined types

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jonathan Daugherty <cygnus(at)cprogrammer(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: User-defined types
Date: 2004-11-17 19:09:51
Message-ID: 29787.1100718591@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jonathan Daugherty <cygnus(at)cprogrammer(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Daugherty 2004-11-17 19:10:24 Re: User-defined types
Previous Message Jonathan Daugherty 2004-11-17 18:30:16 User-defined types