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