Re: Function - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Function
Date
Msg-id 20040215113632.Y88869@megazone.bigpanda.com
Whole thread Raw
In response to Function  ("Sumita Biswas (sbiswas)" <sbiswas@cisco.com>)
Responses Re: Function  ("Sumita Biswas (sbiswas)" <sbiswas@cisco.com>)
List 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.


pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: max timestamp
Next
From: Rod Taylor
Date:
Subject: Re: ORDER BY TIMESTAMP_column ASC, NULL first