Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables
Date
Msg-id 12125.1491493226@sss.pgh.pa.us
Whole thread Raw
In response to Partition-wise join for join between (declaratively) partitioned tables  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> ... But the underlying point here is that
> the only thing you really know about the function is that it's got to
> be a strategy-3 operator in some btree opclass; if that guarantees
> strictness, then so be it -- but I wasn't able to find anything in the
> code or documentation off-hand that supports that contention, so we
> might need to think a bit more about why (or if) this is guaranteed to
> be true.

FWIW, I do not think that follows.  If you want to check that the
function is strict, check that explicitly.

It's very likely that in practice, all such functions are indeed strict,
but we don't have an assumption about that wired into the planner.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: [HACKERS] Uninitialized variable introduced in 3217327053638085d24dd4d276e7c1f7ac2c4c6b
Next
From: Fujii Masao
Date:
Subject: Re: [HACKERS] pg_stat_wal_write statistics view