Re: Fw: pop-up multiselection array and where condition - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Fw: pop-up multiselection array and where condition
Date
Msg-id 46D535B5.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Fw: pop-up multiselection array and where condition  (giuseppe.derossi@email.it)
List pgsql-admin
>>> On Wed, Aug 29, 2007 at  1:53 AM, in message
<6e07a86b040326879dfe5a7bfb1337c5@164.129.1.43>, <giuseppe.derossi@email.it>
wrote:
>  I've to perform a where condition which includes the output from a
>  multiselectio pop-up: ie user can choose one or more item from a pop-up
>  munu, let's say (item1,item3,item10), then I want to send this set of
> values
>  as an array or table via php to a query that should have as where condition
>  some like that:
>
>  select * from table1 where field1 is in (array{item1,item3,item10})

Have you tried?:

select * from table1 where field1 in (item1,item3,item10)

-Kevin




pgsql-admin by date:

Previous
From: Ben Kim
Date:
Subject: Re: How to monitor resources on Linux.
Next
From: Robert Treat
Date:
Subject: Re: how is pitr replay interruption time determined?