Re: RES: [SQL] Joins between int and int[]

2006-06-28 Thread Achilleus Mantzios
want. If your queries are ad-hoc then go the first approach. > Thanks in advance! > > > -Mensagem original- > De: Achilleus Mantzios [mailto:[EMAIL PROTECTED] > Enviada em: quarta-feira, 28 de junho de 2006 04:01 > Para: Rodrigo Sakai > Assunto: Re: [SQL] J

RES: [SQL] Joins between int and int[]

2006-06-28 Thread Rodrigo Sakai
: [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 constr

[SQL] Joins between int and int[]

2006-06-27 Thread Rodrigo Sakai
  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.