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

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 by    AND PD.PDPONUM = 1734 (Hardcode
> a given value) I get a result row.
>
> 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?  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.

--
Michael Fuhr