R: Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Scott Mead <scott(dot)lists(at)enterprisedb(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>, "adrian(dot)klaver" <adrian(dot)klaver(at)gmail(dot)com>
Subject: R: Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour
Date: 2010-01-14 08:41:10
Message-ID: 3eff28921001140041o7f82f2b4q4d62a6194040a95c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us> ha scritto:

Scott Mead <scott(dot)lists(at)enterprisedb(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yan Cheng Cheok 2010-01-14 08:49:32 Memory Access Violation While Using PQexec
Previous Message Pavel Stehule 2010-01-14 08:34:22 Re: Functions - how to get the date created or updated