Arrya variable as argument to IN expression

From: Emil Kaffeshop <emildg(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Arrya variable as argument to IN expression
Date: 2005-11-17 08:28:51
Message-ID: 20051117082851.65703.qmail@web32704.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello I am trying the following:
a INTEGER[] := ''{10,15,20}'';
b INTEGER := 15;
flag BOOLEAN := FALSE;

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 ?

Best Regards
Emil kafegiiski


__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andy Ballingall 2005-11-17 08:44:24 idea for a geographically distributed database: how best to implement?
Previous Message John McCawley 2005-11-16 17:16:36 Performance of a view