|Subject||Re: [firebird-support] Re: 'when' conditions limits in case expression|
> --- In email@example.com, Thomas Steinmaurer<ts@...> wrote:I would rather create a mapping/lookup table and join the two tables.
>> 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.
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist
Do you care about the future of Firebird? Join the Firebird Foundation: