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 get

select * from usp_Commande_Dues_Retourner('{"1734"}', 'M', '2005-02-02', '2005-11-02', 'EN' );

and it works ...
Thanks !
/David



That is, is there
a reason you're using '{\'1734\'}' instead of '{1734}'?  Does using
the latter work?  It does for me in simple tests.

Thanks for your answer.  That was my error.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to