Re: [HACKERS] Case statement ready! - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] Case statement ready!
Date
Msg-id 36745BDB.2AC263B2@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] Case statement ready?  (jwieck@debis.com (Jan Wieck))
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] redolog - for discussion
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Date/time on glibc2 linux