01-19-2015 02:37 PM
Hi All - I am receiving the following error:
ERROR: Result of WHEN clause 2 is not the same data type as the preceding results.
The problem is, how can I find out which When clause is the culprit? There are many when clauses in my query...
01-19-2015 03:28 PM
That is annoying.
Without knowing more about what your doing - a binary search is possible.
Comment out half of when clauses and run code. If you get the error its in the section that's uncommented. Repeat until it's narrowed down.