|
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.
|
