Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 1A1159FC392
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 10 Aug 2007 03:16:34 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 49376-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 10 Aug 2007 03:16:30 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by postgresql.org (Postfix) with SMTP id 2EBF29FC0BE
	for <pgsql-sql@postgresql.org>; Fri, 10 Aug 2007 03:16:29 -0300 (ADT)
Received: (qmail 16469 invoked by uid 0); 10 Aug 2007 06:16:28 -0000
Received: from 84.75.95.14 by www058.gmx.net with HTTP;
	Fri, 10 Aug 2007 08:16:28 +0200 (CEST)
Content-Type: text/plain; charset="iso-8859-1"
Date: Fri, 10 Aug 2007 08:16:28 +0200
From: "Christian Kindler" <christian.kindler@gmx.net>
Message-ID: <20070810061628.206070@gmx.net>
MIME-Version: 1.0
Subject: Re: Returnd Refcurser (<unnamed portal x> not fetchable
To: "Penchalaiah P." <penchalaiahp@infics.com>, pgsql-sql@postgresql.org
X-Authenticated: #27759442
X-Flags: 0001
X-Mailer: WWW-Mail 6100 (Global Message Exchange)
X-Priority: 3
X-Provags-ID: V01U2FsdGVkX1/AWa4EyybAEalzQD1xmPvplCghNqw4JTIuzVNWzh
	AxzEmxLWp1eMuEJMsxEd4AE3KDHN7a4mLykw==
Content-Transfer-Encoding: 8bit
X-GMX-UID: jzWOd0t4IydmAHf202Zr/IFSa2FkZhVm
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.007 tagged_above=0 required=5 tests=AWL=-1.006,
	BAYES_50=0.001, FAKE_REPLY_C=2.012
X-Spam-Level: *
X-Archive-Number: 200708/71
X-Sequence-Number: 29009

Sorry but this didn't help ...

Can not return next ... so I changed the returns as too but same effect as the first function:

drop table foo;
create table foo(sirname text, name text);
insert into foo values ('Mueller', 'Marcus');

drop function getfoo(char(1));
create or replace function getfoo(char(1)) returns setof refcursor as
'
declare 
   ref refcursor;

begin
   open ref for select * from foo where sirname like ''%'' || $1 || ''%'';
   return next ref;
end;   
'
LANGUAGE 'plpgsql' VOLATILE;

select * from getfoo('M');
-- fetch all in '<unnamed portal 14>';


ERROR:  syntax error at or near "'<unnamed portal 14>'" at character 15

-- 
cu
Chris

Psssst! Schon vom neuen GMX MultiMessenger gehört?
Der kanns mit allen: http://www.gmx.net/de/go/multimessenger