Re: Bug: Reverting Return Type

On Fri, Mar 21, 2014 at 11:29 AM, Thangalin <thangalin@gmail.com> wrote:

Hi,

Create a new function that uses a TABLE return type definition:

CREATE OR REPLACE FUNCTION testing(IN p_test bigint)
  RETURNS TABLE (id int) AS
$BODY$
  SELECT 1 AS id
$BODY$
  LANGUAGE sql STABLE;

Expected Results
The return type retains the ID column name and continues to use a
TABLE for the result.

Actual Results
When viewed in pgAdmin3, it becomes:

CREATE OR REPLACE FUNCTION testing(IN p_test bigint)
  RETURNS SETOF integer AS
$BODY$
  SELECT 1 AS id
$BODY$
  LANGUAGE sql STABLE
  COST 100
  ROWS 1000;

The TABLE return type definition has been replaced.

This has no immediate effect on the database, but any subsequent edits
to the function through pgAdmin could catch developers unaware.


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