| From: | Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | R: Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour |
| Date: | 2010-01-13 22:00:47 |
| Message-ID: | 3eff28921001131400s600ab57awce6a5f6852557dc0@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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)
Il giorno 13 gen, 2010 10:53 p., "Adrian Klaver" <adrian(dot)klaver(at)gmail(dot)com>
ha scritto:
On 01/13/2010 01:39 PM, Vincenzo Romano wrote: > > My issue involves the
USING predicates, though. >...
WARNING:Old joke
Doctor: What is wrong?
Patient: My elbow hurts when I do this, what should I do?
Doctor: Quit doing that.
USING is not working the way you want, mainly for the reason you found, the
CHECK is being parsed before the variable is substituted. At this point it
is time to do something different.
--
Adrian Klaver adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2010-01-13 22:02:18 | Re: Collate order on Mac OS X, text with diacritics in UTF-8 |
| Previous Message | Adrian Klaver | 2010-01-13 21:53:13 | Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour |