Database Reference
In-Depth Information
''
THEN
NULL
ELSE
prefix_fmil
END,
CASE
trim(suffix)
WHEN
''
THEN
NULL
ELSE
suffix || '.'
END);
RETURN pfmil_suffix;
END;
$$
LANGUAGE plpgsql;
The idea here is that when any element of a full name is missing, the surrounding
punctuation and white space should also be missing. This function returns a well
formatted full name of a person in the USA, with as much of the name filled in as
possible. When running this function, you will see the following:
