Re: [BUGS] Refcursor problem

2002-01-08 Thread Jan Wieck
Tom Lane wrote: > Dmitry Fomichev <[EMAIL PROTECTED]> writes: > > I am running 7.2b3 and trying to make something like this work (new > > refcursor stuff): > > > CREATE TABLE t (c text); > > > CREATE FUNCTION errtest(refcursor, text) RETURNS refcursor AS ' > > BEGIN > > OPEN $1 FOR SELECT

Re: [BUGS] Refcursor problem

2002-01-03 Thread Tom Lane
Dmitry Fomichev <[EMAIL PROTECTED]> writes: > I am running 7.2b3 and trying to make something like this work (new > refcursor stuff): > CREATE TABLE t (c text); > CREATE FUNCTION errtest(refcursor, text) RETURNS refcursor AS ' > BEGIN > OPEN $1 FOR SELECT c FROM t WHERE c=$2; > R

[BUGS] Refcursor problem

2002-01-03 Thread Dmitry Fomichev
Hi, I am running 7.2b3 and trying to make something like this work (new refcursor stuff): CREATE TABLE t (c text); CREATE FUNCTION errtest(refcursor, text) RETURNS refcursor AS ' BEGIN OPEN $1 FOR SELECT c FROM t WHERE c=$2; RETURN $1; END; ' LANGUAGE 'plpgsql'; INSERT INTO t V