PostgreSQL : Store Procedure Lanjutan

Di postgreSQL jika kita mau membuat store procedure yang merefer ke
field field tertentu bisa dideklarasikan tipe data field tersebut.. jadi
sewaktu2x field tersebut berubah datatypenya .. storeprocedurenya tetap ikut

Contoh :

create table trade.tbl_Sample (
comp_name varchar(20) ,
comp_inet inet
);

create or replace function trade.tbl_Sample_getIt( i_comp_name
trade.tbl_Sample.com_Name%TYPE)
return void
as
$$
DECLARE
com_IPAddress trade.tbl_Sample.com_inet%TYPE;
BEGIN
select com_IPAddress = comp_inet from trade.tbl_sample
where comp_nane =$1;
END;
$$language 'plpgsql';