Re: Incorrect display type of the function result

What you say is almost the same as I reported

Guillermo Villanueva

2015-04-20 11:45 GMT-03:00 Алексей Лутовинин <crossrw1(at)gmail(dot)com>:

> Hello!
>
> pgAdmin 1.20.0 (Dec 16 2014, rev: REL-1_20_0)
> OS: Windows 7/64.
>
> Create a function that returns a table with a column "col1":
>
> CREATE OR REPLACE FUNCTION myfunc()
> RETURNS TABLE(col1 text) AS
> $BODY$
> SELECT 'aaa'::text;
> $BODY$
> LANGUAGE sql STABLE;
>
> After creating a look at the source code of the function in the object
> browser:
>
> CREATE OR REPLACE FUNCTION myfunc()
> RETURNS SETOF text AS
> $BODY$
> SELECT 'aaa'::text;
> $BODY$
> LANGUAGE sql STABLE
> COST 100
> ROWS 1000;
> The type of result of the function is shown as "SETOF text" instead "TABLE(col1
> text)", column name "col1" is lost.
> Despite this, the name of the column "col1" is present in the results:
>
> SELECT * FROM myfunc();
>
> col1 !
> text !
> ----------+-
> aaa |
>
> Сommand-line utility "psql" returns (\df+) correct value of function type.
>
>