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.                                     

Reply via email to