Bug #709: PL/pgSQL Parameter Of Composite Type

CNLIOU (cnliou(at)eurosport(dot)com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
PL/pgSQL Parameter Of Composite Type

Long Description
Hello!

"Example 23-4. A PL/pgSQL Function on Composite Type" says that we are allowed to pass record to pl/pgsql, but actually we are not. Perhaps either the online document or the TODO list should be revised.

Regards,

CN

Sample Code
CREATE TABLE table3(column1 integer);

CREATE FUNCTION test2(table3) RETURNS TEXT AS '
DECLARE
rec ALIAS FOR $1;
BEGIN
RETURN rec.column1;
END;' LANGUAGE 'plpgsql';

CREATE FUNCTION test1() RETURNS TEXT AS '
DECLARE
rec RECORD; --or "rec table3%ROWTYPE;
BEGIN
SELECT * INTO rec FROM table3 LIMIT 1;
RETURN test2(rec);
END;' LANGUAGE 'plpgsql';

Gets:
database=# select test1();
NOTICE: Error occurred while executing PL/pgSQL function test1
NOTICE: line 5 at return
ERROR: Attribute 'rec' not found

No file was uploaded with this report