Re: behavior of ' = NULL' vs. MySQL vs. Standards

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: behavior of ' = NULL' vs. MySQL vs. Standards
Дата
Msg-id 7323.991908030@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: behavior of ' = NULL' vs. MySQL vs. Standards  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-sql
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
>> A compromise answer might be to offer a SET variable that selects the
>> Microsoft-compatible misimplementation.  Would that fly?

> It would for me.  I'd rather have the default be the spec correct behavior
> and let people configure their server to follow the misinterpretation.

Yes, I agree.

> Is the conversion just the hack in the grammar rules for 
> a_expr '=' a_expr?

AFAIK that's it.  It might be a little tricky to do cleanly,
though, since gram.y shouldn't look at SET vars.  Really, the
conversion would have to be done in analyze.c instead.
        regards, tom lane


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

Предыдущее
От: David BOURIAUD
Дата:
Сообщение: About table column names.
Следующее
От: "guard"
Дата:
Сообщение: how to configure --with-tcl in CYGWIN