Postgres Pro
Downloads
Home   >   mailing lists

Re: How to update rows from a cursor in PostgreSQL - Mailing list pgsql-general

From Tom Lane
Subject Re: How to update rows from a cursor in PostgreSQL
Date
Msg-id 5814.1046018398@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to update rows from a cursor in PostgreSQL  (Ruben <ruben12@superguai.com>)
List pgsql-general
Tree view 
Ruben <ruben12@superguai.com> writes:
> Shouldn't it be better then to use "oid" instead of ctid?

Only if you (a) have an OID column and (b) have a unique index created
on the OID column.  ctid is nice because it doesn't incur any indexing
overhead ...

            regards, tom lane

pgsql-general by date:

Previous
From: Carlos Moreno
Date:
Subject: Re: Strange error (Socket command option unknown)
Next
From: Tom Lane
Date:
Subject: Re: Strange error (Socket command option unknown)