From: Rodrigo Sakai <rodrigo.sakai@zanthus.com.br>
To: 'Achilleus Mantzios' <achill@matrix.gatewaynet.com>
Cc: pgsql-sql@postgresql.org
Subject: RES: Joins between int and int[]
Date: Wed, 28 Jun 2006 11:31:18 -0300
Message-ID: <002501c69abf$84d524f0$4700a8c0@TREEZANTHUS> (raw)
In-Reply-To: <Pine.LNX.4.44.0606280958420.8110-100000@matrix.gatewaynet.com>
Thanks Mantzios, your answer helped a lot! But I have a lot of multi column
foreign keys! Any other ideia??
Thanks in advance!
-----Mensagem original-----
De: Achilleus Mantzios [mailto:achill@matrix.gatewaynet.com]
Enviada em: quarta-feira, 28 de junho de 2006 04:01
Para: Rodrigo Sakai
Assunto: Re: [SQL] Joins between int and int[]
O Rodrigo Sakai Ýãñáøå óôéò Jun 27, 2006 :
> Hi,
>
>
>
> I want to use the system catalog tables/views to query some things, and
> one of the queries I have to do is joining pg_attribute and pg_constraint
to
> know what constraint belongs to which table.attribute. My question is how
> can I write the join clause between a int (pg_attribute.attnum) and int[ ]
> (pg_constraint.conkey).
Are you having tables with multi column foreign keys?
e.g. (a,b) REFERENCES partable(para,parb).
If not then join with pg_constraint.conkey[1],
if yes then the problem becomes a little less trivial.
>
>
>
>
>
> The query is:
>
>
>
> select relname, attname, attnotnull, atthasdef
>
> from pg_class as pc
>
> inner join pg_attribute as pa
>
> on pc.oid=pa.attrelid
>
> inner join pg_constraint pcons
>
> on pc.oid=pcons.conrelid
>
> and pa.attnum = pcons.conkey -------> the problem
>
>
>
>
>
> Thanks!!!
>
>
>
>
--
-Achilleus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rodrigo.sakai@zanthus.com.br, achill@matrix.gatewaynet.com
Subject: Re: RES: Joins between int and int[]
In-Reply-To: <002501c69abf$84d524f0$4700a8c0@TREEZANTHUS>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox