>nope...it's an array of composite types, each type with one field, and
>array of two ints. this is waht you wanted? what are you trying to do
>exactly?
yeah, that is quite what I want, just was "surprised" by the way psql displayed the result. What I am doing:
I have a table:
key1 key2 key3 infofield
and need/want to transform it into a new dataset with:
key1, array([key3, infofield])
where key2=:externvalue
using that new type from sam I can do that now.
Many thanks!
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
LASIK good, steroids bad?
