What version of pgAdmin II are you using?
On Fri, Mar 21, 2014 at 11:29 AM, Thangalin <thanga...@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 > -- -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company<http://www.enterprisedb.com> *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi>
