This function creates a string consisting of n number of spaces.
n
space::=
SELECT 'x'||SPACE(5)||'x' my_string;