回复:Re: BUG #14330: can not select into `composite data types` in plpgsql

Hi

2016-09-21 5:51 GMT+02:00 <zoulx1982@163.com>:

The following bug has been logged on the website:

Bug reference:      14330
Logged by:          lx zou
Email address:      zoulx1982@163.com
PostgreSQL version: 9.5.1
Operating system:   win7  6.1.7601
Description:

Hi,
    when i use composite type in plpgsql, i found it does't work when i
select a composite type column into a composite type variable.
    But it can work well when i use another style like this:
    select (y).a,(y).b into tmp from t....
following is a full example. Thanks.

create type mytype(a int, b text);
create table mytab(x int, y mytype);
insert into mytab values(1, (1, 'abcd'));
do $$
declare
        tmp mytype;
begin
        --ERROR:  invalid input syntax for integer: "(1,asddd)"
        --CONTEXT:  PL/pgSQL function inline_code_block line 6 at SQL statement
        select y into strict tmp from mytab;
        raise notice '%,%', (tmp).a, (tmp).b;
end;
$$;

It is not bug - although I understand so this behave is not unfriendly. The pattern composite var := composite value is not supported due possible ambiguous assignment internally in PLpgSQL implementation.

Regards

Pavel Stehule
 

It is no

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs