Subject Re: 'when' conditions limits in case expression
Author Cristiano
--- 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.