Re: Incorrect display type of the function result

2015-04-20 11:45 GMT-03:00 Алексей Лутовинин <crossrw1@gmail.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.