Postgres Pro
Downloads
Home   >   mailing lists

Re: Fast reference without an index? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Fast reference without an index?
Date
Msg-id 10055.1107896327@sss.pgh.pa.us
Whole thread Raw
In response to Fast reference without an index?  (pgsql@mohawksoft.com)
Responses Re: Fast reference without an index?  (pgsql@mohawksoft.com)
List pgsql-hackers
Tree view 
pgsql@mohawksoft.com writes:
> Is there a way, and if I'm being stupid please tell me, to use something
> like a row ID to reference a row in a PostgreSQL database? Allowing the
> database to find a specific row without using an index?

ctid ... which changes on every update ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: "external indices" ...
Next
From: Tom Lane
Date:
Subject: Re: "external indices" ...