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: 20041231061905.91947.qmail@web50005.mail.yahoo.com (view raw or flat)
Thread:
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
column).

>  pls can u help me . can u send me one example of
> cursur using above. 
> 
I think you can find that here:
http://www.postgresql.org/docs/7.3/static/plpgsql-cursors.html

regards,
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 http://noticias.espanol.yahoo.com

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-2014 The PostgreSQL Global Development Group