Re: [SQL] Function Issue!

2004-08-18 Thread Tom Lane
Theo Galanakis <[EMAIL PROTECTED]> writes: > Can anyone tell me what is wrong with the function below ? > CREATE OR REPLACE FUNCTION "public"."theo_test2" () RETURNS OPAQUE AS' > BEGIN >declare curr_theo cursor for select * from node_names; >fetch next from curr_theo; >close curr_theo

[SQL] Function Issue!

2004-08-18 Thread Theo Galanakis
Title: Function Issue! Can anyone tell me what is wrong with the function below ? It throws an ERROR:  syntax error at or near "FETCH" at character 551 CREATE OR REPLACE FUNCTION "public"."theo_test2" () RETURNS OPAQUE AS' BEGIN    declare curr_theo cursor for select * from node_names;    f