X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 6D4C7B439A9 for ; Wed, 9 Jul 2003 05:29:21 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 13681-09 for ; Wed, 9 Jul 2003 02:29:10 -0300 (ADT) Received: from mail.maximizelearning.com (unknown [203.129.229.163]) by svr1.postgresql.org (Postfix) with SMTP id 8A965B43961 for ; Wed, 9 Jul 2003 02:29:07 -0300 (ADT) Received: from Comp0117 ([203.129.229.166] RDNS failed) by mail.maximizelearning.com with Microsoft SMTPSVC(5.0.2195.5329); Wed, 9 Jul 2003 10:59:52 +0530 Message-ID: <006b01c345db$10851f60$5d0410ac@maximizelearning.com> From: "adivi" To: Subject: executing a function Date: Wed, 9 Jul 2003 10:59:26 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0068_01C34609.29D87F10" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-OriginalArrivalTime: 09 Jul 2003 05:29:52.0298 (UTC) FILETIME=[1F5F00A0:01C345DB] X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=ASCII_FORM_ENTRY, BAYES_30, HTML_40_50 X-Spam-Level: * X-Archive-Number: 200307/93 X-Sequence-Number: 14207 This is a multi-part message in MIME format. ------=_NextPart_000_0068_01C34609.29D87F10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, i doubt if this should 've gone to the novice group, but it's all sql i have a function that returns a setof rows from a table testtab : ___________________________________________________________________________= _________ CREATE FUNCTION "public"."gettesttab" () RETURNS SETOF public.testtab AS' select * from TestTab; 'LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER; ___________________________________________________________________________= _________ "volatile" etc. was added by the EMS PostGreSql Manager. i try to execute this function but a call=20 "select * from gettesttab();" or "select gettesttab();" return the error ERROR: syntax error at or near "select" the postmaster window also logs the erros: ERROR: syntax error at or near "select" WARNING: plpgsql: ERROR during compile of gettesttab near line 1 can simeone please help me out with this.=20=20 thanks in advance =20=20=20=20 regards -pawan ------=_NextPart_000_0068_01C34609.29D87F10 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

i doubt=20 if this should 've gone to the novice group, but it's all sql

i have a functi= on that=20 returns a setof rows from a table testtab :

__________________________________________________________________= __________________

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

__________________________________________________________________= __________________

"volatile" etc. was added by = the EMS=20 PostGreSql Manager.

i try to execute this function

but a call

"select * from gettesttab();"

or

"select gettesttab();"

return the error

ERROR: syntax error at or near "select"

the postmaster window also logs the erros:

ERROR: syntax error at or near "select"
WARNING: plpgsq= l:=20 ERROR during compile of gettesttab near line 1

can simeone please help me out&nbs= p;with=20 this.

thanks in advance

regards
-pawan

------=_NextPart_000_0068_01C34609.29D87F10--