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.
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 |