Incorrect display type of the function result

From: Алексей Лутовинин <crossrw1(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Incorrect display type of the function result
Date: 2015-04-20 14:45:11
Message-ID: CAKu6uVasrjfqcMZfbHbrQLwj8rY0-mO7hLk=5TtXiamTq1VOYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message RAMARAJSARAVANAKUMAR 2015-04-21 01:33:52 very difficult to install in windows 8 64 bit
Previous Message Wander Nauta 2015-04-20 11:54:23 Re: pgadmin3 segfaults on leaving context menu