On 21 February 2018 at 22:45, Rajkumar Raghuwanshi <rajkumar.raghuwan...@enterprisedb.com> wrote: > select count(*) from prt1 x where (x.a,x.b) in (select t1.a,t2.b from prt1 > t1,prt2 t2 where t1.a=t2.b) > and (x.c) in (select t3.c from plt1 t3,plt2 t4 where t3.c=t4.c);
Thanks for the test case. It seems like the x.c Param for some reason has a ParamId of 0. I need to go learn a bit more about Params to understand why this is. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
