Re: [GENERAL] Counting rows in a PL/PgSQL CURSOR without fetching?

Reg Me Please <regmeplease@gmail.com> writes:
> Unuckily
> MOVE LAST FROM curs1;
> won't work with
> GET DIAGNOSTICS cnt = ROW_COUNT;

Hmm, you're right that MOVE doesn't set row_count (because plpgsql
itself isn't fetching the rows), but it kinda seems like it should.

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general