Re: [GENERAL] help with writing stored procedure

2005-11-10 Thread Jaime Casanova
On 11/10/05, Assad Jarrahian <[EMAIL PROTECTED]> wrote: > Hi, > I am trying to write a stored procedure that takes as input an array > (one or more integers) and returns all rows matching that ID (primary > key of the table): > > I have this so far: > > CREATE OR REPLACE FUNCTION > getLMs(int[],f

[GENERAL] help with writing stored procedure

2005-11-10 Thread Assad Jarrahian
Hi, I am trying to write a stored procedure that takes as input an array (one or more integers) and returns all rows matching that ID (primary key of the table): I have this so far: CREATE OR REPLACE FUNCTION getLMs(int[],float(8), float(8)) RETURNS SETOF tp_lm_object AS $$ DECLARE myrec r