Database Reference
In-Depth Information
Conditional expressions
Conditional expressions allow developers to control the action of the function based
on a defined criteria. The following is an example of using a
CASE
statement to control
how a string is treated based on its value. If the value is null, or contains a zero length
string, it is treated the same as null.
CREATE OR REPLACE FUNCTION format_us_full_name(
prefix text,
firstname text,
mi text, lastname
text,
suffix text)
RETURNS text AS
$$
DECLARE
fname_mi text;
fmi_lname text;
prefix_fmil text;
pfmil_suffix text;
BEGIN
fname_mi := CONCAT_WS(' ',
CASE
trim(firstname)
