Horton
Menu

Re: PL/pgSQL EXECUTE '..' USING with unknown

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Cédric Villemain <cedric.villemain.debian@gmail.com>
Cc: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-08-17T14:29:40Z
Lists: pgsql-hackers 
=?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?

			regards, tom lane