Re: Problem with array in plpgsql function .. please help

[David Gagnon <dgagnon@xxxxxxxxxx>]

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