Subject Re: [firebird-support] Re: 'when' conditions limits in case expression
Author Thomas Steinmaurer
> --- In, Thomas Steinmaurer<ts@...> wrote:
>> Is your question theoretical for some kind of case study or DBMS
>> comparison thingy or did you hit a limit already? Just curious. ;-)
> In really, is a practical question.
> I have to classify some records (about 300k) in many categories (nearly 200). So, I thought do this directly in the select statement (using case clause). However, write a query with 200 conditions "when ... then..." to, at the end, the debugger tell you that you reached the conditions limits is kind annoying.

I would rather create a mapping/lookup table and join the two tables.

With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

Do you care about the future of Firebird? Join the Firebird Foundation: