Re: executing a function

From: Matthew Horoschun <mhoroschun(at)canprint(dot)com(dot)au>
To: "adivi" <adivi(at)maximizelearning(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: executing a function
Date: 2003-07-09 05:49:20
Message-ID: 15D7B7BA-B1D1-11D7-BB21-000393B3A702@canprint.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rudi Starcevic 2003-07-09 06:55:57 Re: Logging select statements
Previous Message adivi 2003-07-09 05:29:26 executing a function