Re: [BUGS] BUG #2441: All useable indexes for an IN are used, not just one

2006-05-18 Thread Tom Lane
"Arjen van der Meijden" <[EMAIL PROTECTED]> writes: > filled with enough data to have it use indexes, it yields a plan involving > all three indexes with this query: > select * from testcase where somefk in (1, 2) and someswitch; > Bitmap Heap Scan on testcase (cost=7.43..330.58 rows=136 width=

Re: [BUGS] Bug in PL/Perl 8.1.3

2006-05-18 Thread Tom Lane
Chana Slutzkin <[EMAIL PROTECTED]> writes: > In 8.1.3, a PL/Perl function that returns 'SETOF', > when used in the SELECT list of a query, generates the following error: > "set-valued function called in context that cannot accept a set" This is a consequence of http://archives.postgresql.org/pgs

[BUGS] Bug in PL/Perl 8.1.3

2006-05-18 Thread Chana Slutzkin
In 8.1.3, a PL/Perl function that returns 'SETOF', when used in the SELECT list of a query, generates the following error: "set-valued function called in context that cannot accept a set" Hence there does not seem to be any way of using a PL/Perl function that returns 'SETOF' on non-constant in