MySQL Forums
Forum List  »  PostgreSQL

Advanced Search
New Topic

How can I declare a variable of type RECORD?
Posted by: Denis Voitenko
Date: May 20, 2006 11:45PM

I am trying to port a stored procedure from PostgreSQL which has the following in it:

DECLARE
person RECORD;

BEGIN
SELECT INTO person name_first,name_middle,name_last FROM people WHERE id=person_id;

<snip>

it seems MySQL 5.0.21 doesn't support type RECORD in stored procs or triggers. How can I replicate this behavior?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How can I declare a variable of type RECORD?
14371
Denis Voitenko
May 20, 2006 11:45PM
Re: How can I declare a variable of type RECORD?
10081
Bob Field
May 21, 2006 12:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.