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

Поиск
Список
Период
Сортировка
От Vincenzo Romano
Тема R: Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour
Дата
Msg-id 3eff28921001131400s600ab57awce6a5f6852557dc0@mail.gmail.com
обсуждение исходный текст
Ответ на Weird EXECUTE ... USING behaviour  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Ответы Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour
Список 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.klaver@gmail.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.klaver@gmail.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: R: Re: R: Re: Weird EXECUTE ... USING behaviour
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Collate order on Mac OS X, text with diacritics in UTF-8