Function - Mailing list pgsql-sql

From Sumita Biswas (sbiswas)
Subject Function
Date
Msg-id 01a001c3f15d$099afa70$2a154d0a@apac.cisco.com
Whole thread Raw
Responses Re: Function
List pgsql-sql
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;
beginselect * FROM tbl_error_master;
end;
'
LANGUAGE SQL;

psql:Proc_ConferenceSummary.sql:9: ERROR:  parser: parse error at or
near "int" at character 31

I don't see any Syntax Error. Can you please let me know what can be the
issue?

Regards,
Sumita



pgsql-sql by date:

Previous
From: "Ivo Anon"
Date:
Subject: nextval problem
Next
From: "Greg Patnude"
Date:
Subject: Re: determining how many products are in how many categories