Database Reference
In-Depth Information
RETURNS text AS
$$
DECLARE
fname_mi text;
fmi_lname text;
prefix_fmil text;
pfmil_suffix text;
BEGIN
fname_mi := CONCAT_WS(' ',
IF(trim(firstname) ='',NULL,firstname),
IF(trim(mi) =
'', NULL, mi || '.')
);
fmi_lname := CONCAT_WS(' ',
IF(fname_mi
= '',NULL, fname_mi),
IF(trim(lastname) = '', NULL, lastname)
);
prefix_fmil := CONCAT_WS('. ',
IF(trim(prefix) = '', NULL, prefix),
