From: | Dennis Gearon <gearond(at)cvc(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | use of %TYPE |
Date: | 2003-02-27 22:44:30 |
Message-ID: | WTKHGBB9764Y2JG610465F0S9704IE.3e5e94ce@cal-lab |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Can I use %TYPE in a function definition a la:
=============================================================================
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,
Emails.email%TYPE,
UsrEmailTypes.usr_email_type%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_email_addr_type ALIAS FOR $7;
BEGIN
RETURN ''f'';
END;
' LANGUAGE 'plpgsql';
=============================================================================
Also, does pgsql keep case in the table and column names? phpPgAdmin shows no case on tables I
created with case.
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Gearon | 2003-02-28 00:46:03 | Using %TYPE in function defs |
Previous Message | John Gray | 2003-02-27 22:40:44 | Re: XML in PostgreSQL |