The following bug has been logged online: Bug reference: 4911 Logged by: Brian Ceccarelli Email address: cecca...@talussoftware.com PostgreSQL version: 8.4 Operating system: Windows, Linux Description: Cannot assign a value to a member of a nested composite type. Details:
In PL/pgsql, I cannot do: a.b.id := 1; Where a and b are composite type variables. Example. Run the following: --------------------------------------------- drop type if exists type_sp_status cascade; create type type_sp_status as ( number_of_errors int4 ); drop type if exists type_sp_all cascade; create type type_sp_all as ( status type_sp_status ); CREATE OR REPLACE FUNCTION f_test() RETURNS int4 AS $BODY$ declare a type_sp_all; begin a.status.number_of_errors := 1; raise notice 'number of errors = %', a.status.number_of_errors; return 0; end; $BODY$ LANGUAGE 'plpgsql' STABLE; --------------------------------------------- -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
