Re: calling stored procedure with array paramenter (for psql) - Mailing list pgsql-general

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?


On 1/9/06, Michael Fuhr <mike@fuhr.org> wrote:
> On Mon, Jan 09, 2006 at 05:33:53PM -0700, Assad Jarrahian wrote:
> > I have a pg_psql stored procedure
> >
> > getlms(_int4)
> >
> > from psql
> >
> > SELECT * fROM get_lms(ARRAY[12,23,34]);
> >
> > that does not work. How do I pass an array to a function in psql?
>
> Could you explain what "does not work" means?  Are you getting an
> error?  If so, what's the error message?
>
> Are those the real function names?  They don't match so that could
> be the problem (one is getlms, the other is get_lms).  If that's
> not it then please post a simple but complete example.
>
> --
> Michael Fuhr
>