Re: [GENERAL] Problem with array in plpgsql function .. please help

2005-11-03 Thread David Gagnon
Hi When I call the same function select * from usp_Commande_Dues_Retourner('{\'1734\'}', 'M', '2005-02-02', '2005-11-02', 'EN' ); with the real line I get no result? Why are you quoting the value inside the quotes? Because I had a bug in my java application. I modify my code to

Re: [GENERAL] Problem with array in plpgsql function .. please help :-)

2005-11-03 Thread Michael Fuhr
On Wed, Nov 02, 2005 at 10:19:53PM -0500, David Gagnon wrote: > I cannot find what is the problem with my function below. The > following line in the function :AND PD.PDPONUM = ANY (receivingIds) > don't work. If I change this line byAND PD.PDPONUM = 1734 (Hardcode > a given value) I