Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.klaver@xxxxxxxxx> 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.klaver@xxxxxxxxx


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux