CNLIOU ([EMAIL PROTECTED]) 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
