Re: PL/pgSQL - Help or advice please on using unbound cursors - Mailing list pgsql-general

From Andrew Hastie
Subject Re: PL/pgSQL - Help or advice please on using unbound cursors
Date
Msg-id 500FF61C.4000608@ahastie.net
Whole thread Raw
In response to Re: PL/pgSQL - Help or advice please on using unbound cursors  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Yep, that fixed it. Many thanks for the pointer.

 From a performance point of view, I did look at using MOVE rather than
FETCH before I call UPDATE as I don't actually need to read the data
before applying the update. However in this situation, the ROW_COUNT is
always zero and can't be used which I suspect is reasonable.

Anyway, thanks for the help.

pgsql-general by date:

Previous
From: leo xu
Date:
Subject: how to calculate or know seq_scan scan how many blocks every time
Next
From: BJ Freeman
Date:
Subject: upgrade causes psql to not work