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:[EMAIL PROTECTED] Sent: Monday, February 16, 2004 1:07 AM To: Sumita Biswas (sbiswas) Cc: [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
