Re: Function

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: "Sumita Biswas (sbiswas)" <sbiswas(at)cisco(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Function
Date: 2004-02-15 19:36:45
Message-ID: 20040215113632.Y88869@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

  • Function at 2004-02-12 11:40:38 from Sumita Biswas (sbiswas)

Responses

  • Re: Function at 2004-02-16 08:12:01 from Sumita Biswas (sbiswas)

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2004-02-15 19:51:52 Re: max timestamp
Previous Message Rod Taylor 2004-02-15 19:02:49 Re: ORDER BY TIMESTAMP_column ASC, NULL first