Re: [HACKERS] Array-fields and many-to-many relations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alke <alke(at)iol(dot)it>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] Array-fields and many-to-many relations
Date: 1999-08-23 14:23:51
Message-ID: 23277.935418231@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alke <alke(at)iol(dot)it> writes:
> Well, this query doesn't work because in the SELECT ... the operator
> "IN" can work only on subselect, not on array... how can I check if an
> element belongs to an array or not?

contrib/array has a slightly ugly solution to your problem.

regards, tom lane

Browse pgsql-hackers by date

  From Date Subject
Next Message José Soares 1999-08-23 15:18:05 Re: [HACKERS] ERROR: pull_var_clause: Cannot handle node type 108
Previous Message Tom Lane 1999-08-23 14:21:24 Re: [HACKERS] ERROR: pull_var_clause: Cannot handle node type 108