Home > mailing lists

Re: Check ref cursor - Mailing list pgsql-sql

From	Pavel Stehule
Subject	Re: Check ref cursor
Date	May 31, 2021 18:39:29
Msg-id	CAFj8pRBG8qMP6puJEkhq=WFyL3iX1k5FGYobNWVLb6-s7coTGg@mail.gmail.com Whole thread Raw
In response to	Check ref cursor (Yambu <hyambu@gmail.com>)
List	pgsql-sql

po 31. 5. 2021 v 16:38 odesílatel Yambu <hyambu@gmail.com> napsal:

Hello

How do i check if ref cursor is pointing to empty data?

you can use FETCH command, and check variable FOUND

FETCH xx INTO var;

IF NOT FOUND THEN ...

Regards

Pavel

regards

From: Yambu
Date: 31 May 2021, 17:37:57
Subject: Check ref cursor

From: Yambu
Date: 03 June 2021, 16:43:09
Subject: Update to whole table