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
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? |