From: Tom Lane <tgl@sss.pgh.pa.us>
To: Brian Karlak <zenkat@metaweb.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: maintaining a reference to a fetched row
Date: Wed, 04 Nov 2009 00:31:26 -0500
Message-ID: <8800.1257312686@sss.pgh.pa.us> (raw)
In-Reply-To: <22AC581D-50D1-4863-9FDE-35EDDB171269@metaweb.com>
References: <22AC581D-50D1-4863-9FDE-35EDDB171269@metaweb.com>
Brian Karlak <zenkat@metaweb.com> writes:
> My question is this: is there some way that I can keep a cursor /
> pointer / reference / whatever to the row I fetched originally, so
> that I don't have to search for it again when I'm ready to write
> results?
If you don't expect any updates to the row meanwhile, ctid might serve.
regards, tom lane
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-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, zenkat@metaweb.com
Subject: Re: maintaining a reference to a fetched row
In-Reply-To: <8800.1257312686@sss.pgh.pa.us>
* 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