Re: BUG #9817: Broken index detection in case of functions with variadic array parameters

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dmitry-ryabov(at)mail(dot)ru
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #9817: Broken index detection in case of functions with variadic array parameters
Date: 2014-04-04 02:04:24
Message-ID: 22002.1396577064@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

dmitry-ryabov(at)mail(dot)ru writes:
> -- BUG! index scan isn't used
> select * from test where test_value_func(value, 'a', 'b') > 60;
> -- index scan used
> select * from test where test_value_func(value, VARIADIC ARRAY['a'::text,
> 'b'::text])>60

I've committed a fix for this. Thanks for the report!

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message harukat 2014-04-04 10:22:16 BUG #9849: walreceiver's DEBUG message reports wrong timestamp
Previous Message Shahar 2014-04-04 01:47:21 Re: BUG #9833: daterange is not utilizing index correctly