PgFoundry Logo
     Advanced search
Log In
New Account
  
 
Home My Page Project Tree Project Openings Npgsql .Net Data Provider for Postgresql
 
 
 
 
Summary Forums Tracker Lists Tasks Docs Surveys News SCM Files
 
 

Forums | Admin

Discussion Forums: help

Start New Thread Start New Thread
Message: 1004942
BY: Josh Cooley (jbcooley)
DATE: 2009-05-09 23:45
SUBJECT: RE: Sending a list in the statement

 

You already have an array, you don't need to run it through STRING_TO_ARRAY. Try this:

SELECT product_id, product, qty FROM products where product_id = ANY(:productIdList)

That's a modified version of the query in your first post.


Thread View

Thread Author Date
Sending a list in the statementHarvinder Singh2009-05-08 20:38
      RE: Sending a list in the statementJosh Cooley2009-05-09 02:12
            RE: Sending a list in the statementHarvinder Singh2009-05-09 15:33
                  RE: Sending a list in the statementJerónimo Milea2009-05-09 16:00
                        RE: Sending a list in the statementJosh Cooley2009-05-09 16:11
                              RE: Sending a list in the statementJerónimo Milea2009-05-09 16:14
                  RE: Sending a list in the statementJerónimo Milea2009-05-09 16:20
                        RE: Sending a list in the statementHarvinder Singh2009-05-09 20:25
                              RE: Sending a list in the statementJosh Cooley2009-05-09 23:45
                                    RE: Sending a list in the statementHarvinder Singh2009-05-10 11:17

Post a followup to this message