Re: array indizes in SQL

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