Re: array indizes in SQL - Mailing list pgsql-novice

From Hans-Peter Oeri
Subject Re: array indizes in SQL
Date
Msg-id 4738671A.6000306@oeri.ch
Whole thread Raw
In response to Re: array indizes in SQL  ("Rodrigo De León" <rdeleonp@gmail.com>)
Responses Re: array indizes in SQL  ("Rodrigo De León" <rdeleonp@gmail.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: "Rodrigo De León"
Date:
Subject: Re: array indizes in SQL
Next
From: "Rodrigo De León"
Date:
Subject: Re: array indizes in SQL