Re: maintaining a reference to a fetched row

From: Brian Karlak <zenkat(at)metaweb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: maintaining a reference to a fetched row
Date: 2009-11-04 17:25:27
Message-ID: 10FE20B6-051E-4E26-9B69-33D39F589125@metaweb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Nov 3, 2009, at 9:31 PM, Tom Lane wrote:

> Brian Karlak <zenkat(at)metaweb(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Brian Karlak 2009-11-04 17:41:54 Re: maintaining a reference to a fetched row
Previous Message Anj Adu 2009-11-04 16:58:07 Re: High Frequency Inserts to Postgres Database vs Writing to a File