From: Anton Prokofiev <a.d.prokofiev@googlemail.com>
Subject: return %ROWTYPE from function
Date: Sun, 23 May 2010 14:42:38 -0700 (PDT)
Organization: http://groups.google.com
Lines: 31
Message-ID: 
 <0b4febda-32f3-4346-bb99-4d5197464f19@i31g2000vbt.googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Complaints-To: groups-abuse@google.com
Injection-Info: i31g2000vbt.googlegroups.com; posting-host=88.152.252.35;
	posting-account=5AYfhgoAAAAS4ReDQf98B33xa-p1oSNp
User-Agent: G2/1.0
To: pgsql-sql@postgresql.org

Hello, All!

I've tried to do following:

create table test ( id BIGSERIAL NOT NULL, constraint pk_test primary
key (id),
                          val BIGINT NOT NULL
                        );


create or replace function get_rec (in p_id test.id%TYPE) returns test
%ROWTYPE  as $$
declare
   retval test%ROWTYPE;
begin
   select * from test into retval
   where id = $1;
   return retval;
end;
$$ language 'plpgsql';


I got an error message: "sysntax error  at or near ROWTYPE"

Is it possible to return ONE record that has the same type as table?

I Oracle it is work fine....

Any Ideas or work around?

Thanks.