devolver cadena de texto

[[movorack]]

Hola,

Básicamente debes establecer el tipo de datos a devolver por la función y asignar el valor dentro de la misma función.


http://www.postgresql.org/docs/9.1/s...efunction.html

Código SQL [-]
CREATE FUNCTION check_password(uname TEXT, pass TEXT)
RETURNS BOOLEAN AS $$
DECLARE passed BOOLEAN;
BEGIN
        SELECT  (pwd = $2) INTO passed
        FROM    pwds
        WHERE   username = $1;

        RETURN passed;
END;
$$  LANGUAGE plpgsql
    SECURITY DEFINER
    -- Set a secure search_path: trusted schema(s), then 'pg_temp'.
    SET search_path = admin, pg_temp;