Hello 2008/12/10 Oleg Serov <[EMAIL PROTECTED]>: > 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 > -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
