2010/8/17 Cédric Villemain <cedric.villemain.debian@gmail.com>:
> 2010/8/17 Tom Lane <tgl@sss.pgh.pa.us>:
>> =?ISO-8859-1?Q?C=E9dric_Villemain?= <cedric.villemain.debian@gmail.com> writes:
>>> 2010/8/16 Tom Lane <tgl@sss.pgh.pa.us>:
>>>> =?ISO-8859-1?Q?C=E9dric_Villemain?= <cedric.villemain.debian@gmail.com> writes:
>>>>> Unfortunely the current implementation of EXECUTE USING is not working
>>>>> this way.
>>>>
>>>> Uh ... what do you base that statement on?
>>
>>> About the planning behavior ?
>>> With USING, I get a seqscan (cost and long), without USING I have an
>>> indexscan(short and costless).
>>
>> It works as expected for me. What PG version are you using exactly?
>> Could you provide a self-contained example?
>
> postgresql 8.4.4. Yes I'll work one out this evening.
> more or less : table foo (uid char(32) PK, flag boolean), uids are
> md5sum. +-6M rows.
Here we are. A simple usecase.
--
Cédric Villemain 2ndQuadrant
http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support