Hi!
Rodrigo De León wrote:
Is there a better way to "decompose" an array? (that I didn't find)
SELECT a.attname AS "primarykey"
FROM pg_catalog.pg_attribute AS a, pg_catalog.pg_constraint AS o
WHERE a.attnum = ANY (o.conkey)
AND a.attrelid = o.conrelid
AND o.contype = 'p'
AND o.conrelid = CAST ( ? AS regclass)
ORDER BY a.attnum ASC
Thanks for your input... However, you're ignoring the index field order - which might differ from attribute order. At least some querys need 'correct' index orders, like foreign key (field) relations: the field at index position 2 in table a relates to the field at index position 2 in table b.
HPO