Postgres Pro
Downloads
Home   >   mailing lists

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

From Emil Kaffeshop
Subject Arrya variable as argument to IN expression
Date
Msg-id 20051117082851.65703.qmail@web32704.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Arrya variable as argument to IN expression
Re: Arrya variable as argument to IN expression
Re: Arrya variable as argument to IN expression
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: John McCawley
Date:
Subject: Performance of a view
Next
From: Achilleus Mantzios
Date:
Subject: Re: Arrya variable as argument to IN expression