Re: [PATCHES] reqd patch

--- 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