ERROR: syntax error at or near "("
LINE 15: (row_main_table.subtype).flag := FALSE; -- cannot set
^
********** Ошибка **********
ERROR: syntax error at or near "("
SQL state: 42601
Характеристика:321
2008/12/10 Pavel Stehule <[EMAIL PROTECTED]>:
> 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 ([email protected])
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-bugs
>>
>
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
