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