Postgres Pro
Downloads
Home   >   mailing lists

Counting rows in a PL/PgSQL CURSOR without fetching? - Mailing list pgsql-general

From Reg Me Please
Subject Counting rows in a PL/PgSQL CURSOR without fetching?
Date
Msg-id 200809251831.06305.regmeplease@gmail.com
Whole thread Raw
Responses Re: Counting rows in a PL/PgSQL CURSOR without fetching?
List pgsql-general
Tree view 
Hi all.
Is there a way in PL/PgSQL to get the number of rows resulting from a:
    OPEN curs1 SCROLL FOR EXECUTE query;
before actually fetching any?

Unuckily
    MOVE LAST FROM curs1;
won't work with
    GET DIAGNOSTICS cnt = ROW_COUNT;

Any hint?

pgsql-general by date:

Previous
From: "A B"
Date:
Subject: on duplicate key
Next
From: Tom Lane
Date:
Subject: Re: regexp_replace() [noindex] thing