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----- |