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