Re: maintaining a reference to a fetched row - Mailing list pgsql-performance

From Brian Karlak
Subject Re: maintaining a reference to a fetched row
Date
Msg-id 10FE20B6-051E-4E26-9B69-33D39F589125@metaweb.com
Whole thread Raw
In response to Re: maintaining a reference to a fetched row  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Nov 3, 2009, at 9:31 PM, Tom Lane wrote:

> 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.

Ahhh ... that's the magic I'm looking for.  Thanks!

Brian

pgsql-performance by date:

Previous
From: Anj Adu
Date:
Subject: Re: High Frequency Inserts to Postgres Database vs Writing to a File
Next
From: Brian Karlak
Date:
Subject: Re: maintaining a reference to a fetched row