By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,852 Members | 2,200 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,852 IT Pros & Developers. It's quick & easy.

User-defined types

P: n/a
Hello,

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:

CREATE TYPE test_type AS (x bigint, y bigint);

CREATE OR REPLACE FUNCTION array_test (test_type[]) ...

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 parser
understands this naming convention, and translates requests for
columns of type foo[] into requests for type _foo. The
implicitly-created array type is variable length and uses the
built-in input and output functions array_in and array_out."

However,

mydb=# SELECT COUNT(*) FROM pg_type WHERE typname = '_test_type';
count
-------
0
(1 row)

Am I missing something? Thanks for your time.

I'm running PostgreSQL 7.4.5.

--
Jonathan Daugherty
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
# > "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.

Ah, I see -- it wasn't obvious to me.

# We don't currently support arrays of composite types. (Nor arrays
# of domain types, either, IIRC.)

Ok, thanks for your time.

--
Jonathan Daugherty
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #2

P: n/a
Jonathan Daugherty <cy****@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

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

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.