Re: [HACKERS] User-defined Operator Pushdown and Collations

2016-11-28 Thread Paul Ramsey
On Sun, Nov 27, 2016 at 11:50 AM, Tom Lane wrote: > Paul Ramsey writes: > > On Sun, Nov 27, 2016 at 9:31 AM, Tom Lane wrote: > >> Why doesn't hs_fdw.h have a collation? > > > I think I'm missing something, I cannot find a file like that anywhere. > > I was referring to the variable shown in you

Re: [HACKERS] User-defined Operator Pushdown and Collations

2016-11-27 Thread Tom Lane
Paul Ramsey writes: > On Sun, Nov 27, 2016 at 9:31 AM, Tom Lane wrote: >> Why doesn't hs_fdw.h have a collation? > I think I'm missing something, I cannot find a file like that anywhere. I was referring to the variable shown in your EXPLAIN. > With respect to this particular example, is this a

Re: [HACKERS] User-defined Operator Pushdown and Collations

2016-11-27 Thread Paul Ramsey
On Sun, Nov 27, 2016 at 9:31 AM, Tom Lane wrote: > Paul Ramsey writes: > > On Fri, Nov 25, 2016 at 11:30 AM, Paul Ramsey > > > wrote: > >> I've been trying to figure out an issue with operators not being pushed > >> down for user defined types, in this case "hstore". TL;DR: > >> > >> hstore=# e

Re: [HACKERS] User-defined Operator Pushdown and Collations

2016-11-27 Thread Tom Lane
Paul Ramsey writes: > On Fri, Nov 25, 2016 at 11:30 AM, Paul Ramsey > wrote: >> I've been trying to figure out an issue with operators not being pushed >> down for user defined types, in this case "hstore". TL;DR: >> >> hstore=# explain (verbose) select * from hs_fdw where h -> 'a' = '1'; >> QUE

Re: [HACKERS] User-defined Operator Pushdown and Collations

2016-11-25 Thread Paul Ramsey
On Fri, Nov 25, 2016 at 11:30 AM, Paul Ramsey wrote: > I've been trying to figure out an issue with operators not being pushed > down for user defined types, in this case "hstore". TL;DR: > > hstore=# explain (verbose) select * from hs_fdw where h -> 'a' = '1'; > QUE

[HACKERS] User-defined Operator Pushdown and Collations

2016-11-25 Thread Paul Ramsey
I've been trying to figure out an issue with operators not being pushed down for user defined types, in this case "hstore". TL;DR: hstore=# explain (verbose) select * from hs_fdw where h -> 'a' = '1'; QUERY PLAN