[SQL] how to write cursors
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
Re: [SQL] how to write cursors
Hello use a refcursors http://www.postgresql.org/docs/9.1/static/plpgsql-cursors.html Regards Pavel Stehule 2012/4/4 La Chi : > 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 > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
