From: Richard Huxton <dev@archonet.com>
To: andrew@pillette.com
Cc: pgsql-sql@postgresql.org
Subject: Re: MOVE in SQL vs PLPGSQL
Date: Wed, 05 Oct 2005 09:18:39 +0100
Message-ID: <43438C5F.9070502@archonet.com> (raw)
In-Reply-To: <200510032057.j93KvFF28447@pillette.com>
References: <200510032057.j93KvFF28447@pillette.com>
andrew@pillette.com wrote:
> I can't find a good way to skip over a large number of records in
> PLPGSQL (I want to fast-forward and I don't need the I/O of reading
> and throwing away hundreds of records.) In SQL, I could just use
> MOVE. That doesn't appear to be supported in PLPGSQL?! Help?
Andrew - your question doesn't seem to make sense - can you give some
more details? Are you having some problem with cursors in plpgsql?
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, andrew@pillette.com
Subject: Re: MOVE in SQL vs PLPGSQL
In-Reply-To: <43438C5F.9070502@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox