1.18.1 (Jan 21 2014, REL-1_18_1)
Linux 3.2.0-60-generic #91-Ubuntu SMP Wed Feb 19 03:54:44 UTC 2014 x86_64
x86_64 x86_64 GNU/Linux
Ubuntu Trusty Tahr (development branch) \n \l
What version of pgAdmin II are you using?
On Fri, Mar 21, 2014 at 11:29 AM, Thangalin 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$
>
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
