--- ramesh phule <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] or [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
