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 VashiEnterpriseDB INDIA: Enterprise PostgreSQL Company
http://www.linkedin.com/in/asheshvashi
pgadmin-support by date:
Соглашаюсь с условиями обработки персональных данных