CASE construct

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: Postgres Hackers List <hackers(at)postgresql(dot)org>
Subject: CASE construct
Date: 1998-11-12 05:48:38
Message-ID: 364A76B6.8A48C521@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I've gotten part-way toward implementing a CASE construct in Postgres:

select
case when i = 1 then 10
when i = 2 then 20
end
from t;

(the other parts of the case clause are supported also). But I'm running
into problems in the executor, in that although the query tree seems to
be well-formed, there is not a corresponding plan or plan tree (not sure
of the terminology). Any suggestions on where to start, or interest in
working on it? (hint, hint)

btw, I'm hoping to have a superset of the SQL92 definition; the standard
allows only constants in the "then" clauses afaik, but I'm shooting for
allowing full expressions...

- Tom

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dmitry Samersoff 1998-11-12 07:24:22 Re: <string>
Previous Message Thomas G. Lockhart 1998-11-12 05:22:37 Re: [HACKERS] CORBA interface in backend?