Re: PL/pgSQL - Help or advice please on using unbound cursors

From: Andrew Hastie <andrew(at)ahastie(dot)net>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: PL/pgSQL - Help or advice please on using unbound cursors
Date: 2012-07-25 13:35:24
Message-ID: 500FF61C.4000608@ahastie.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message BJ Freeman 2012-07-25 14:57:05 upgrade causes psql to not work
Previous Message Alexander Law 2012-07-25 11:54:23 Re: BUG #6742: pg_dump doesn't convert encoding of DB object names to OS encoding