return %ROWTYPE from function

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.