Postgres Pro
Downloads
Home   >   mailing lists

Re: Arrya variable as argument to IN expression - Mailing list pgsql-sql

From Tom Lane
Subject Re: Arrya variable as argument to IN expression
Date
Msg-id 25702.1132237417@sss.pgh.pa.us
Whole thread Raw
In response to Arrya variable as argument to IN expression  (Emil Kaffeshop <emildg@yahoo.com>)
List pgsql-sql
Tree view 
Emil Kaffeshop <emildg@yahoo.com> writes:
> SELECT b IN (a) INTO flag; !!! does not work

> Is it legal to expect the array to be interpret as
> list of integers which IN expression takes ?

No.  But try "b = any (a)".
        regards, tom lane

pgsql-sql by date:

Previous
From: Andy Ballingall
Date:
Subject: idea for a geographically distributed database: how best to implement?
Next
From: "codeWarrior"
Date:
Subject: Re: idea for a geographically distributed database: how best to implement?