dbTalk Databases Forums  

CREATE TYPE containing array of user-defined type elements

comp.databases.postgresql comp.databases.postgresql


Discuss CREATE TYPE containing array of user-defined type elements in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jorge S. de Lis
 
Posts: n/a

Default CREATE TYPE containing array of user-defined type elements - 10-14-2007 , 06:25 AM






-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi there!

We're trying to create a user-defined type in PostgreSQL 8.2 containing an
array of an element whose type is another user-defined one. We're facing a
problem here, since when we try to do so:

CREATE TYPE newtype AS(
x double precision,
y double precision
);

CREATE TYPE newtype2(
INPUT=array_in,
OUTPUT=array_out,
ELEMENT=newtype
);

PostgreSQL complains about non-existent array_out(newtype2). So, we felt
into this forum
http://osdir.com/ml/db.postgresql.no.../msg00147.html and someone
suggested creating an alias to array_out because postgresql >= 7.3 is too
much strict about data types ot whatever.

Since we can't access as admin, we can't solve the problem like that. We
can't create an alias for array_out if we're not admins.

Please, we need some help. Thank you.

- --
Jorge S. de Lis <gentakojima (AT) gmail (DOT) com>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iQIVAwUBRxH8x6vCV+KC5A6ZAQJpKxAAgpeHCeDfy/jZ421zs/3tDhNBeQavF2h9
aLRdHV9kiXuB4+NL73tAiTPzqXs042MdDQxKmq3Bg2/WMkgwR2f04hEdWGN8a6hj
JtUKJY29i5BU2gfnfoep/yN6oyTN0qj6Vn2VRryx2cyAX4iA3KxIPpeJpTE9xMsX
S7KFuG+3AC4zSaFqlVt5bczbzm+wrWH4UPLho6FMsZTSo7TLru CWbApL4qRWlSrL
AgG6KFKuT1zNN82SVt6v29KTB80/YBfbHKoUqWn1dJPl/aqVDYH4HKZxR6fZyt2F
WRxPnXjtAAVzPkEJQyqtJpxLQlJ/t0XfGPJ0NZzHXrSnLSp0ms2MxsXn66qLAzXW
yYPF2fadDkh+0RB+mb2Sp6n7cCvRQjx0df56gQysQscYoEtV8d rRGHzmoOwsIJaV
fTSmfrpwkkIlPHB314ERfXFJ6jno50vJBv3syP4jYvNlKonsM5 PCp/UpvEZgBBh6
jhFzoNsP6zbqv5/GKYiBuo5TsfQWSo38K3l6rLtynvaNhpQ8PBnWwiityciSB2G9
N77NghXU87MbHSD6pCOgCbt5ykncaKtPRPuPp3EcQuvVal75M4 ND7DRyNDQ6v74H
shpva7fz0w37Bgh65D+MofeaCK3kEwkReYQ4sdN/X400yCQcl97G41rbcMf/tj0u
LUzf5GRmxfw=
=mKq/
-----END PGP SIGNATURE-----

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.