Re: calling stored procedure with array paramenter (for psql)

On Mon, Jan 09, 2006 at 08:17:17PM -0700, Assad Jarrahian wrote:
> CREATE OR REPLACE FUNCTION getlms(_int4)
> RETURNS SETOF tp_locationmessage_object AS
> $BODY$
> DECLARE
> .......
>
>
> SELECT * FROM getLMs(<what_goes_here>);
>
> <what_goes_here> ... so lets say I want to send an array contain 1,23,34 ...
>
> how do I do that .. whats the syntax?

Either of the following should work:

SELECT * FROM getlms(ARRAY[1,23,34]);
SELECT * FROM getlms('{1,23,34}');

The first looks like what you said you tried already, so if it still
doesn't work then please post a complete example. The problem might
be in the function body, not in how you're calling the function,
so we need to see what the function is doing.

--
Michael Fuhr