Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] reqd patch

From: Jaime Casanova <systemguards(at)yahoo(dot)com>
To: ramesh phule <ramesh_success(at)yahoo(dot)com>,pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: [PATCHES] reqd patch
Date: 2004-12-31 06:19:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-patches
 --- ramesh phule <ramesh_success(at)yahoo(dot)com> escribió:

>  Dear Sir,
>  I am working as Teacher in college.
>  I am teaching PostgreSQL to student.
>  I am facing problem in running CURSOR. version  of
> postgresql is 7.3.2
An old version, maybe you want to update to 7.4.6. In
the next days/weeks?? will be out the vwersion 8. with
great improvements.

>     Cursor creation and fetching works fine.
>   but , 1) refcursor datatype is not recognised by
> postgres
refcursor datatype is deprecated in newer versions,
you can do the same with the DECLARE CURSOR statement
or with Set Returning Functions (Functions that
returns more than one row).

>         2) fetch curs1 into curs2 , is not working.
is curs2 a variable of the same datatype og the column
you retrieved from the select? (i suppose is only one

>  pls can u help me . can u send me one example of
> cursur using above. 
I think you can find that here:

Jaime Casanova

PD: The patches mailing list is not appropiate for
this kind of questions, maybe you want to use
novice-pgsql(at)postgresql(dot)org or
general-pgsql(at)postgresql(dot)org(dot) I will redirect this
post to general

Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en

In response to

  • reqd patch at 2004-12-31 05:26:48 from ramesh phule

pgsql-patches by date

Next:From: Simon RiggsDate: 2004-12-31 11:46:49
Subject: Re: [HACKERS] Bgwriter behavior
Previous:From: Michael FuhrDate: 2004-12-31 06:09:46
Subject: Re: [PATCHES] reqd patch

pgsql-general by date

Next:From: Bruno Wolff IIIDate: 2004-12-31 06:21:40
Subject: Re: Large Objects
Previous:From: Bruno Wolff IIIDate: 2004-12-31 06:15:04
Subject: Re: Tracking back foreign keys?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group