Re: A couple of TODO notes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: A couple of TODO notes
Date
Msg-id 18086.1066707755@sss.pgh.pa.us
Whole thread Raw
In response to Re: A couple of TODO notes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: A couple of TODO notes  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql-server/src backend/main/main.c backend/t ...
Next
From: Christopher Browne
Date:
Subject: Re: pg_autovacuum and VACUUM FREEZE