Re: Odd system-column handling in postgres_fdw join pushdown patch - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Odd system-column handling in postgres_fdw join pushdown patch
Date
Msg-id 17346.1460572462@sss.pgh.pa.us
Whole thread Raw
In response to Re: Odd system-column handling in postgres_fdw join pushdown patch  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Apr 13, 2016 at 1:36 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>> I tend to favor zeroes rather than NULLs, because that's what we
>> typically use to represent an invalid value of those types, and I'm
>> not aware of any current case where those values are NULL.

> In fact, see heap_attisnull.

Right, a table's system columns cannot be null at the table-scan level.
(But they could go to null above an outer join.)
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Odd system-column handling in postgres_fdw join pushdown patch
Next
From: Robert Haas
Date:
Subject: Re: Odd system-column handling in postgres_fdw join pushdown patch