Re: [HACKERS] Too many duplicated condition query return wrong value

2015-09-07 Thread Atsushi Yoshida
uot;public.attend" If I want to detect the same thing, should I execute REINDEX sometimes? Do you have any good ideas? Thanks. --- http://github.com/yalab Atsushi YOSHIDA http://twitter.com/yalab inject your heart > 2015/09/07 7:47、Jeff Janes のメール: > > On Thu, Sep 3, 2015 a

Re: [HACKERS] Too many duplicated condition query return wrong value

2015-09-04 Thread Atsushi Yoshida
quot; FROM > "attend" WHERE "attend"."sid" = 325 AND "attend"."lid" IN ('ABF0010', > 'ABF0020', 'ABF0030', 'ABF0040', 'ABF0050', 'ABF0060') > > Index Scan using in

[HACKERS] Too many duplicated condition query return wrong value

2015-09-03 Thread Atsushi Yoshida
ABF0040', 'ABF0040', 'ABF0040', 'ABF0040', 'ABF0040', 'ABF0040', 'ABF0040', > 'ABF0040', 'ABF0040', 'ABF0040', 'ABF0040', 'ABF0040', 'ABF0040', 'ABF0040', > 'ABF0040', 'ABF0040', 'ABF0040', 'ABF0040',