In Redshift database, functions are called from within a select statement as shown below:
SELECT function_name(function_arg1, function_arg2,...);
Example: Below is the syntax to call a function named “full_name” which accepts 2 string parameters for first_name and last_name.
SELECT full_name('first_name','last_name');