BUG #4911: Cannot assign a value to a member of a nested composite type.

Поиск
Список
Период
Сортировка
От Brian Ceccarelli
Тема BUG #4911: Cannot assign a value to a member of a nested composite type.
Дата
Msg-id 200907092046.n69KkjuM091613@wwwmaster.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4911
Logged by:          Brian Ceccarelli
Email address:      ceccareb@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;

---------------------------------------------

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jack Douglas
Дата:
Сообщение: Re: BUG #4908: escaping and dollar quotes: "ERROR: unterminated string"
Следующее
От: "Tom Bowden"
Дата:
Сообщение: BUG #4912: server core dumps on xslt_process with empty param string