Vertica User defined SQL function
Posted: Tue Mar 29, 2016 1:31 pm
Hi,
I was creating a user defined SQL function using a create or replace function statement.
My function converts a numerical value to its range ie if my input value is 213 the output should be 200-300.
I have written a logic and created function. When i try to run the function, it gives me compilation error for long.
After a long search, i found in a blog on the restrictions of vertica that "For now, there is no support for Variables, loops with User Defined SQL Functions".
Could anyone confirm that, if this is correct and vertica user defined sql funtions does not support variables and loops.
Thanks,
Saveetha
I was creating a user defined SQL function using a create or replace function statement.
My function converts a numerical value to its range ie if my input value is 213 the output should be 200-300.
I have written a logic and created function. When i try to run the function, it gives me compilation error for long.
After a long search, i found in a blog on the restrictions of vertica that "For now, there is no support for Variables, loops with User Defined SQL Functions".
Could anyone confirm that, if this is correct and vertica user defined sql funtions does not support variables and loops.
Thanks,
Saveetha