Обсуждение: cursor return null

Поиск
Список
Период
Сортировка

cursor return null

От
Ramesh T
Дата:
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;

Re: cursor return null

От
David G Johnston
Дата:
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.