Re: Is there a way to create a functional index that tables tableoid column as an arg? - Mailing list pgsql-general

From Tom Lane
Subject Re: Is there a way to create a functional index that tables tableoid column as an arg?
Date
Msg-id 1883.1520974336@sss.pgh.pa.us
Whole thread Raw
In response to Re: Is there a way to create a functional index that tables tableoidcolumn as an arg?  (Ryan Murphy <ryanfmurphy@gmail.com>)
List pgsql-general
Ryan Murphy <ryanfmurphy@gmail.com> writes:
> Hi David!  Thanks for the reply.
>> tableoid might be an exception to
>> this, but it does not really seem like a useful column to index,
>> giving it would be indexing the same value for each record in the
>> table.

> Unless you're using inheritance - then tableoid may vary.  That's the case
> I'm interested in.

Uh, no, not within a single table ... and indexes only cover one table.

            regards, tom lane


pgsql-general by date:

Previous
From: Ryan Murphy
Date:
Subject: Re: Is there a way to create a functional index that tables tableoidcolumn as an arg?
Next
From: Peter Eisentraut
Date:
Subject: Re: query_to_xml() returns invalid XML when query returns no rows