Re: Fw: pop-up multiselection array and where condition

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <giuseppe(dot)derossi(at)email(dot)it>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Fw: pop-up multiselection array and where condition
Date: 2007-08-29 14:00:38
Message-ID: 46D535B5.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>>> On Wed, Aug 29, 2007 at 1:53 AM, in message
<6e07a86b040326879dfe5a7bfb1337c5(at)164(dot)129(dot)1(dot)43>, <giuseppe(dot)derossi(at)email(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Treat 2007-08-29 14:44:17 Re: how is pitr replay interruption time determined?
Previous Message Ben Kim 2007-08-29 13:41:03 Re: How to monitor resources on Linux.