Re: A couple of TODO notes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: A couple of TODO notes
Дата
Msg-id 18086.1066707755@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: A couple of TODO notes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: A couple of TODO notes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> * Allow INET subnet tests using non-constants
>> This should say "Allow ... to be indexed" as it's otherwise a nonissue.

> New text is:
>     * Allow INET subnet tests to use indexes
> Is that right?

No, because we already index subnet tests against constants.  (It's pretty
much like the situation for "column LIKE anchored-pattern" --- we
transform to an indexable range-test.)

>> This is either done or rendered irrelevant, depending on your point of
>> view, by the V3 protocol.

> Do we allow SELECT data to come back as BINARY form (not C strings)
> like we do with BINARY cursors?

Yes, you can make that happen in the V3 protocol: you can select either
text or binary output format for each column.  Declaring a cursor BINARY
is in fact irrelevant in V3 protocol.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [COMMITTERS] pgsql-server/src backend/main/main.c backend/t ...
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: pg_autovacuum and VACUUM FREEZE