| From: | "Radhika Vutukuru" <rvutukur(at)saraf(dot)com> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | working with stored procedures |
| Date: | 2001-05-14 19:41:28 |
| Message-ID: | 001c01c0dcad$de53f130$77bdd93f@saraf.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi ,
I am trying to create a stored procedure that returns a user defined type. The following piece of code shows the way I am trying to do it.
regy1=> create function regyuser_rec(int) returns varchar as ' declare
regy1'> v_userid alias for $1;
regy1'> output_rec varchar(400);
regy1'> user_rec record;
regy1'>
regy1'> begin
regy1'>
regy1'> select fname ,lname into user_rec from regyuser
regy1'> where userid = v_userid;
regy1'> output_rec := user_rec;
regy1'> return output_rec;
regy1'> end;
regy1'> ' language 'plpgsql';
CREATE
regy1=> select regyuser_rec(2);
ERROR: Attribute 'user_rec' not found
Does a postgresql function returns a user defined object?
If so, could I have an example.
I am new to postgresql, and was trying to figure out what's wrong with my code.Could some one help me.
Thanks,
Radhika.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-05-14 20:39:21 | Re: Case |
| Previous Message | Jeff MacDonald | 2001-05-14 18:16:14 | Re: execute client application from PL/pgSql |