Re: [SQL] Problem in Stored Procedures

2004-07-10 Thread Rajesh Kumar Mallah
Pradeepkumar, Pyatalo (IE10) wrote: Hi all, I m using Postgresql version 7.1.3-2. The create type and create function does work in PostgreSQL 7.4 without any modification. I guess the features you are trying to use are not supported in 7.1.x Regds Mallah. I have written a function which accepts

[SQL] Problem in Stored Procedures

2004-07-09 Thread Pradeepkumar, Pyatalo (IE10)
Hi all, I m using Postgresql version 7.1.3-2. I have written a function which accepts 2 arguments and returns matching tuples from a table based on the arguments passed...but i am having problems in getting it work. This is my function - CREATE TYPE PointType AS(ParamId INTEGER,ParamName VAR