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.