How to call a function in Redshift database

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');
See also  How to create an S3 bucket from AWS CLI