Обсуждение: cursor return null
Hello,
in postgres function (id bigint ),the following code not return any value with artNums ,But when i do select statement ony it's output the values with out include cursor
i.e,cursor problem ..?
please let me know what should i do to getvalues from cursor, but i dont where i missing
function (id bigint )
DECLARE
PartNums varchar (10000);
artNums CURSOR for
SELECT p.PART_NUM part_num
FROM lineitem sol, part p
WHERE sol.ORDER_ID = id AND p.PART_ID = sol.PART_ID;
BEGIN
FOR cPart IN artNums LOOP
BEGIN
PartNums := PartNums || cPart.part_num || ', ';
END;
rameshparnanditech wrote > Hello, > in postgres function (id bigint ),the following code not return > any value with artNums ,But when i do select statement ony it's output > the > values with out include cursor > > i.e,cursor problem ..? > > please let me know what should i do to getvalues from cursor, but i dont > where i missing > > function (id bigint ) > > DECLARE > PartNums varchar (10000); > artNums CURSOR for > SELECT p.PART_NUM part_num > FROM lineitem sol, part p > WHERE sol.ORDER_ID = id AND p.PART_ID = sol.PART_ID; > > BEGIN > FOR cPart IN artNums LOOP > BEGIN > PartNums := PartNums || cPart.part_num || ', '; > END; You have two BEGIN statements and no "END LOOP" statement...you need to read the documentation and learn the correct syntax for using CURSORS and FOR loops. You should also post the entire function and not just excerpts to minimize the risk of copy/paste problems and not reporting your reality. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/cursor-return-null-tp5812219p5812246.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.