From: | Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> |
---|---|
To: | adrian(dot)klaver(at)gmail(dot)com |
Cc: | Scott Mead <scott(dot)lists(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour |
Date: | 2010-01-14 06:19:57 |
Message-ID: | 3eff28921001132219p1a238596ge288cd1708394ba7@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2010/1/14 Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>:
> On Wednesday 13 January 2010 2:17:51 pm Scott Mead wrote:
>> On Wed, Jan 13, 2010 at 11:00 PM, Vincenzo Romano <
>>
>> vincenzo(dot)romano(at)notorand(dot)it> wrote:
>> > It is not the check or the select.
>> > It is the way the substitution has been implemented. It looks like the
>> > code replaces the variable name and not the value.
>> > Which is different from what is written at page 800.
>> > I only hope they won't change the manual to match the feature/bug
>> > (warning: new joke)
>>
>> Page 800:
>>
>> "Another restriction on parameter symbols is that they only work in SELECT,
>> INSERT, UPDATE, and DELETE commands. In other statement types (generically
>> called utility statements), you must insert values textually even if they
>> are just data values."
>
> Scott, thanks for that I must have read through that section several times at
> least with out picking up on it.
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>
Really?
That section is not in any page of the v8.4.2 documentation either PDF or HTML.
The sentence has been introduced (yesterday?) in 8.5devel, which is
far from being "current".
I only hope they won't change the manual to match the feature/bug
(warning: new joke)
So that was not a joke at all! :-(
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2010-01-14 06:20:45 | Re: Collate order on Mac OS X, text with diacritics in UTF-8 |
Previous Message | Craig Ringer | 2010-01-14 06:15:22 | Re: Collate order on Mac OS X, text with diacritics in UTF-8 |