X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 1447CD1CAE4
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 15 Feb 2004 19:36:46 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 69882-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 15 Feb 2004 15:36:45 -0400 (AST)
Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210])
	by svr1.postgresql.org (Postfix) with ESMTP id 8AF00D1CACB
	for <pgsql-sql@postgresql.org>; Sun, 15 Feb 2004 15:36:44 -0400 (AST)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id 42BE9356A5; Sun, 15 Feb 2004 11:36:45 -0800 (PST)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id 4158B35645; Sun, 15 Feb 2004 11:36:45 -0800 (PST)
Date: Sun, 15 Feb 2004 11:36:45 -0800 (PST)
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: "Sumita Biswas (sbiswas)" <sbiswas@cisco.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Function
In-Reply-To: <01a001c3f15d$099afa70$2a154d0a@apac.cisco.com>
Message-ID: <20040215113632.Y88869@megazone.bigpanda.com>
References: <01a001c3f15d$099afa70$2a154d0a@apac.cisco.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/186
X-Sequence-Number: 16876

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.