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@xxxxxxxx> 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 >
