Hi, all! We have received some users questions about how to send a list of values to be used in queries using the "in" operator. Something like: select foo, bar from table where foo in (blah1, blah2, blah3); Npgsql supports array-like parameter values and the first idea to have this working would try to use it directly: NpgsqlCommand command = new NpgsqlCommand("select * from tablee where field_serial in (:parameterlist)", conn); ArrayList l = new ArrayList(); l.Add(5); l.Add(6); command.Parameters.Add(new NpgsqlParameter("parameterlist", NpgsqlDbType.Array | NpgsqlDbType.Integer)); command.Parameters[0].Value = l.ToArray(); NpgsqlDataReader dr = command.ExecuteReader(); but unfortunately this won't work as expected. Npgsql will send a query like this: select * from tablee where field_serial in ((array[5,6])::int4[]) And Postgresql will complain with the followin...
Comments
Metal Badges
Printing Badges
Lapel Pins Manufacturer
Cuff Links
Metal Badges
Bottle Openers
Medals
key chains
trading pin
Flag Lapel Pins
Police Badge
Coin
wristbands wholesale
Disney Pins Wholesale
mouse pads manufacturer
mouse pads
Lapel Pins Manufacturer
Lapel Pins
Disney Pins Wholesale
Disney Pins Wholesale
电脑外设
电脑周边
电脑周边批发
电脑外设批发
电脑配件批发
摄像头批发
U盘批发
鼠标批发
mp3mp4批发
饰品批发
水晶饰品批发
小饰品批发
韩国饰品批发
925银饰
情侣饰品批发
银饰批发
925银饰批发
流行饰品批发
珠宝首饰批发
泰银批发
小商品批发
饰品免费代销
友情链接
作文
笑话