Reply-To: <sbiswas@cisco.com>
From: "Sumita Biswas (sbiswas)" <sbiswas@cisco.com>
To: "'Stephan Szabo'" <sszabo@megazone.bigpanda.com>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: Function
Date: Mon, 16 Feb 2004 13:42:01 +0530
Organization: cisco systems
Message-ID: <004d01c3f464$8ecf67d0$2a154d0a@apac.cisco.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Importance: Normal
In-Reply-To: <20040215113632.Y88869@megazone.bigpanda.com>

Thanks for the answer.
I have one more issue. How do I test a function that I wrote?
I was able to create a function called Proc_ConferenceSummary().
In SQL Server I used to run it through query analyzer by writing the
following command:
exec Proc_ConferenceSummary '12/1/2003','1/23/2004',1,1,0,5001

But I don't know how to do it in Postgresql.

Any help is appreciated.

Thanks,
Sumita

-----Original Message-----
From: Stephan Szabo [mailto:sszabo@megazone.bigpanda.com] 
Sent: Monday, February 16, 2004 1:07 AM
To: Sumita Biswas (sbiswas)
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Function


On Thu, 12 Feb 2004, Sumita Biswas (sbiswas) wrote:

> Hi All,
>
> This function of mine gives a Parse Error:
>
> CREATE or replace FUNCTION 
> Proc_ConferenceSummary(date,date,int,int,int)
> RETURNS SETOF tbl_error_master AS
> '
> declare
> 	li_CallManagerId int;
> begin
> 	select * FROM tbl_error_master;
> end;
> '
> LANGUAGE SQL;

I think you want plpgsql as the language.