From: | Dennis Gearon <gearond(at)cvc(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Using %TYPE in function defs |
Date: | 2003-02-28 00:46:03 |
Message-ID: | 21ZY7604C0OMMK21X32SOGFNM760421.3e5eb14b@cal-lab |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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';
From | Date | Subject | |
---|---|---|---|
Next Message | Ed L. | 2003-02-28 00:51:05 | Re: 7.4? |
Previous Message | Dennis Gearon | 2003-02-27 22:44:30 | use of %TYPE |