hi every one i have created this simple function which returns a column of table , i have used simple SELECT statement , i simply want to know how can i achieve the same task with the help of cursor
CREATE OR REPLACE FUNCTION foo(id int) returns table(cust_id int) as $BODY$ BEGIN return query Select userid from customer where proname ='shampoo'; END; $BODY$ LANGUAGE plpgsql; how can i write a cursor which should return all the custid who had proname shampoo . i shall be very thankful to you
