Home » PlItems » DB-Funktion erstellen (PL/pgSQL)

DB-Funktion erstellen

ID150
Link ReferenceNot set
Link CreditsNot set
Link Technical DocumentationNot set
PlCodelangPL/pgSQL
PlGroupDatenbank
PlItemTitleDB-Funktion erstellen
CodeCREATE OR REPLACE FUNCTION whichContinent(country TEXT)
RETURNS character varying AS $BODY$
DECLARE returnValue character varying;
BEGIN
SELECT INTO returnValue
CASE country
WHEN 'ARGENTINA' THEN 'SOUTH AMERICA'
WHEN 'BELGIUM' THEN 'EUROPE'
WHEN 'BRAZIL' THEN 'SOUTH AMERICA'
WHEN 'CANADA' THEN 'NORTH AMERICA'
WHEN 'DENMARK' THEN 'EUROPE'
WHEN 'FINLAND' THEN 'EUROPE'
WHEN 'FRANCE' THEN 'EUROPE'
ELSE 'UNKNOWN'
END;

RETURN returnValue;
END;
$BODY$ LANGUAGE PLPGSQL;
Result Example