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