Re: plpgsql bug OR future request: Assign fileds in composite subfiled. eg. table.compositefield.subfield := TRUE; - Mailing list pgsql-bugs

Hello

2008/12/10 Oleg Serov <serovov@gmail.com>:
> SQL:
> CREATE TABLE second_type (
>        flag BOOLEAN
> );
> CREATE TABLE main_type (
>        subtype second_type
> );
> CREATE OR REPLACE FUNCTION "bug_in_tabletypes" () RETURNS pg_catalog.void AS
> $body$
> DECLARE
>        row_main_table main_type%rowtype;
> BEGIN
>        row_main_table.subtype := NULL; -- all okey;



>        row_main_table.subtype.flag := FALSE; -- cannot set

try
  (row_main_table.subtype).flag := FALSE; -- cannot set

regards
Pavel Stehule

> END;
> $body$
> LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;
>
> Will produce error:
>
>
> ERROR:  syntax error at or near "row_main_table"
> LINE 1: row_main_table.subtype.flag := FALSE
>        ^
> QUERY:  row_main_table.subtype.flag := FALSE
> CONTEXT:  SQL statement in PL/PgSQL function "bug_in_tabletypes" near line
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>