Hi, In the following statement, does the custom function get executed twice?
SELECT MY_FUNCTION(...), CASE WHEN MY_FUNCTION(...) = '...' THEN '...' ELSE '...' END ... ... If so, is there a way I can make it execute once? I tried this but it gave me a "Column my_function does not exist" error. SELECT MY_FUNCTION(...) AS my_function, CASE WHEN my_function = '...' THEN '...' ELSE '...' END ... ... Thank you in advance.