i18n and MySQL: a db function has to be written

[christoph]

this is the equivalent in PostgreSQL:

---

-- -- new function gettext for easy translations -- CREATE OR REPLACE FUNCTION gettext(locale_arg "text", string "text") RETURNS "varchar" AS $BODY$ DECLARE

msgstr varchar(512); trl RECORD;

BEGIN

-- RAISE NOTICE '>%<', locale_arg;

SELECT INTO trl * FROM translations WHERE trim(from locale) = trim(from locale_arg) AND msgid = string; -- we return the original string, if no translation is found. -- this is consistent with gettext's behaviour IF NOT FOUND THEN

RETURN string;

ELSE

RETURN trl.msgstr;

END IF;

END; $BODY$

LANGUAGE 'plpgsql' VOLATILE;