Using %TYPE in function defs

Поиск
Список
Период
Сортировка
От Dennis Gearon
Тема Using %TYPE in function defs
Дата
Msg-id 21ZY7604C0OMMK21X32SOGFNM760421.3e5eb14b@cal-lab
обсуждение исходный текст
Список pgsql-general
Answered my own question by TRYING it .... oooooo .... scary for a responsible 44 year old, who
knows the cost of experiments gone wrong. But OTOM, my instllation is just starting so I could
break something and not cry about it.

It is possible to define a function using %TYPE. Maybe this could be put in the manuals?
------------------------------------------------------------
CREATE OR REPLACE FUNCTION add_usr ( Usrs.first_name%TYPE,
                                     Usrs.middle_name%TYPE,
                                     Usrs.sur_name%TYPE,
                                     Usrs.sur_name_extra%TYPE,
                                     Gens.gen%TYPE,
                                     EmailAddrs.email_addr%TYPE,
                                     UsrEmailAddrTypes.usr_email_addr_type%TYPE,
                     UsrEmailAddrs.pri_for_usr%TYPE)
RETURNS BOOLEAN AS '
    DECLARE
    var_first_name          ALIAS FOR $1;
    var_middle_name         ALIAS FOR $2;
    var_sur_name            ALIAS FOR $3;
    var_sur_name_extra      ALIAS FOR $4;
    var_gen                 ALIAS FOR $5;
    var_email_addr          ALIAS FOR $6;
    var_usr_email_addr_type ALIAS FOR $7;
    BEGIN
        RETURN ''f'';
    END;
' LANGUAGE 'plpgsql';






В списке pgsql-general по дате отправления:

Предыдущее
От: "John Gray"
Дата:
Сообщение: Re: XML in PostgreSQL
Следующее
От: "Ed L."
Дата:
Сообщение: Re: 7.4?