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

From Vincenzo Romano
Subject R: Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour
Date
Msg-id 3eff28921001140041o7f82f2b4q4d62a6194040a95c@mail.gmail.com
Whole thread Raw
In response to Weird EXECUTE ... USING behaviour  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Responses Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general

The documentation says (also in v8.5) "These symbols refer to values supplied in the USING clause".
"values"and not "variable name or reference". This leads to the useful feature mentioned a line later in the same page.
Once you have a value replaced you can avoid the restrictions you now mention on v8.5.

What's the right place to submit proposals?

Il giorno 14 gen, 2010 7:42 m., "Tom Lane" <tgl@sss.pgh.pa.us> ha scritto:

Scott Mead <scott.lists@enterprisedb.com> writes: > Well it is in 8.5 Devel, so it could have bee...The particular paragraph mentioned was committed here
http://archives.postgresql.org/pgsql-committers/2009-11/msg00094.php
but as you note it was just a relocation of a comment that appeared
elsewhere for at least two years before that (and even then, it was
just documenting behavior that had existed since day one).

                       regards, tom lane

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Functions - how to get the date created or updated
Next
From: Yan Cheng Cheok
Date:
Subject: Memory Access Violation While Using PQexec