Home > mailing lists

Re: executing a function - Mailing list pgsql-sql

From	Matthew Horoschun
Subject	Re: executing a function
Date	July 9, 2003 05:50:35
Msg-id	15D7B7BA-B1D1-11D7-BB21-000393B3A702@canprint.com.au Whole thread Raw
In response to	executing a function ("adivi" <adivi@maximizelearning.com>)
List	pgsql-sql

Tree view

Hi Pawan,

>    CREATE FUNCTION "public"."gettesttab" () RETURNS SETOF
> public.testtab AS'
>         select * from TestTab;
>     'LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;

You want LANGUAGE 'sql'

Cheers

Matthew.

pgsql-sql by date:

From: "adivi"
Date: 09 July 2003, 05:29:25
Subject: executing a function

From: Achilleus Mantzios
Date: 09 July 2003, 06:41:23
Subject: Re: Logging select statements

Re: executing a function - Mailing list pgsql-sql

Previous

Next