Re: PL/pgSQL EXECUTE '..' USING with unknown - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PL/pgSQL EXECUTE '..' USING with unknown
Date
Msg-id 12154.1282055380@sss.pgh.pa.us
Whole thread Raw
In response to Re: PL/pgSQL EXECUTE '..' USING with unknown  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Responses Re: PL/pgSQL EXECUTE '..' USING with unknown
List pgsql-hackers
Cédric Villemain <cedric.villemain.debian@gmail.com> writes:
> 2010/8/16 Tom Lane <tgl@sss.pgh.pa.us>:
>> Cédric 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


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Todays git migration results
Next
From: Tom Lane
Date:
Subject: Re: Todays git migration results