| Subject | Re: [firebird-support] need help on query |
|---|---|
| Author | Edwin Pratomo |
| Post date | 2003-06-30T06:02:59Z |
On Monday 30 June 2003 10:56, Regina Phandu wrote:
Some uses of CASE are to flatten queries containing some kind of sub-queries,
so I think your CASE query can be rewritten using subquery instead.
rgds,
Edwin.
>CASE expression is supported in Fb 1.5.
> 2. Is firebird support SELECT CASE? Does anyone have any idea how to
> convert a view that are using SELECT CASE to firebird? Can I do it in
> Firebird or I have to make it a store procedure instead of view?
Some uses of CASE are to flatten queries containing some kind of sub-queries,
so I think your CASE query can be rewritten using subquery instead.
rgds,
Edwin.