Re: [PATCHES] reqd patch

 --- ramesh phule <ramesh_success@yahoo.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@postgresql.org or
general-pgsql@postgresql.org. 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