Re: Weird EXECUTE ... USING behaviour

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
Cc: adrian(dot)klaver(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Weird EXECUTE ... USING behaviour
Date: 2010-01-12 15:13:32
Message-ID: 4086.1263309212@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> writes:
> I don't think so. Those variables should be evaluated with the USING
> *before* the actual execution.
> Thus my statements only contain columns and constants.

Unfortunately, that's just wishful thinking, not how EXECUTE USING
actually works.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Gravsjö 2010-01-12 16:19:47 Re: Pre-calculate hash join
Previous Message Vincenzo Romano 2010-01-12 14:54:49 Re: Weird EXECUTE ... USING behaviour