Re: [HACKERS] Case statement ready!

Поиск
Список
Период
Сортировка
От Thomas G. Lockhart
Тема Re: [HACKERS] Case statement ready!
Дата
Msg-id 36745BDB.2AC263B2@alumni.caltech.edu
обсуждение исходный текст
Ответ на Re: [HACKERS] Case statement ready?  (jwieck@debis.com (Jan Wieck))
Список pgsql-hackers
> > > > If anyone has a chance to look at the new code wrt the rewriter
>     I expect that the structures below the two new nodes can also
>     contain Var nodes. And then it's definitely wrong  to  ignore
>     them.   They  must  be handled properly in rewriteHandler and
>     rewriteManip.

I've just committed changes to the main development tree which allow
CASE statement handling for at least some cases of rules and views.

Still have trouble (crashes) with CASE statements involving mixing
columns from multiple tables during joins. But the single-table stuff
(and multi-table when the case statement is confined to a single table)
seems to work for my testing.

I have an update to the CASE regression test which has many more tests,
and will put it in the tree and on this list fairly soon (to get some
Oracle/etc testing of results).
                   - Tom


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] redolog - for discussion
Следующее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Re: [HACKERS] Date/time on glibc2 linux