Re: [BUGS] BUG #1850: parameter WITH HOLD (of function DECLARE CURSOR)

#1

Added to TODO:

o Allow PL/PgSQL to support WITH HOLD cursors

---------------------------------------------------------------------------

Danilo Barbosa wrote:

Quote:

The following bug has been logged online:

Bug reference: 1850
Logged by: Danilo Barbosa
Email address: dusb (AT) airgate (DOT) com.br
PostgreSQL version: 8.1
Operating system: LINUX
Description: parameter WITH HOLD (of function DECLARE CURSOR) not
acepted inside CREATE FUNCTION.
Details:

CREATE OR REPLACE FUNCTION teste2()
RETURNS refcursor AS
$BODY$DECLARE
ref CURSOR WITH HOLD FOR SELECT * FROM tb_ponto;
BEGIN
OPEN ref;
RETURN ref;
END;$BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION teste2() OWNER TO aes_jacui;

The same DECLARE works outside the CREATE FUNCTION.

thank you!

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #1850: parameter WITH HOLD (of function DECLARE CURSOR)

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #1850: parameter WITH HOLD (of function DECLARE CURSOR) - 09-23-2005 , 03:43 PM