| 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: | Whole Thread | Raw Message | 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 |