Re: [HACKERS] Case statement ready!

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Jan Wieck <jwieck(at)debis(dot)com>
Cc: hackers(at)postgreSQL(dot)org, maillist(at)candle(dot)pha(dot)pa(dot)us, vadim(at)krs(dot)ru
Subject: Re: [HACKERS] Case statement ready!
Date: 1998-12-14 00:29:15
Message-ID: 36745BDB.2AC263B2@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-12-14 00:32:45 Re: [HACKERS] Date/time on glibc2 linux
Previous Message Bruce Momjian 1998-12-13 23:57:28 Re: [HACKERS] redolog - for discussion