Re: Weird EXECUTE ... USING behaviour - Mailing list pgsql-general

From Vincenzo Romano
Subject Re: Weird EXECUTE ... USING behaviour
Date
Msg-id 3eff28921001130002g3da24bf3ja7f548d64a465be8@mail.gmail.com
Whole thread Raw
In response to R: Re: Weird EXECUTE ... USING behaviour  (Vincenzo Romano <vincenzo.romano@notorand.it>)
List pgsql-general
2010/1/13 Vincenzo Romano <vincenzo.romano@notorand.it>:
> The static binding worked fine in the second EXECUTE USING statement but not
> in the first one.
> I still think that it's weird more than wishful.
> I can work it around, though.
>
> Il giorno 12 gen, 2010 4:13 p., "Tom Lane" <tgl@sss.pgh.pa.us> ha scritto:
>
> Vincenzo Romano <vincenzo.romano@notorand.it> writes:
>
>> I don't think so. Those variables should be evaluated with the USING >
>> *before* the actual executi...
>
> Unfortunately, that's just wishful thinking, not how EXECUTE USING
> actually works.
>
>                        regards, tom lane
>

Sorry for top posting: I used a mobile phone ...


--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: crosstab function - pivot - use column value as column description
Next
From: Yan Cheng Cheok
Date:
Subject: Extremely Slow Cascade Delete Operation