Re: Is there a way to create a functional index that tables tableoid column as an arg?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Is there a way to create a functional index that tables tableoid column as an arg?
Дата
Msg-id 1883.1520974336@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Is there a way to create a functional index that tables tableoidcolumn as an arg?  (Ryan Murphy <ryanfmurphy@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ryan Murphy
Дата:
Сообщение: Re: Is there a way to create a functional index that tables tableoidcolumn as an arg?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: query_to_xml() returns invalid XML when query returns no rows