Re: [GENERAL] [pgadmin-support] questions about cursors

2007-04-26 Thread Sim Zacks
Anton, Wrong mailing list. You should send this type of query to pgsql-general@postgresql.org in the future. The documentation is confusing, though. Try This: CREATE OR REPLACE FUNCTION database_correction() RETURNS double precision AS $BODY$ DECLARE mycursor CURSOR FOR select distinct(fund_

Re: [GENERAL] [pgadmin-support] questions about cursors

2007-04-24 Thread Anton Andreev
I did already, but this still does not help me write a simple while loop that goes through all data and stops at the last row. Joris Dobbelsteen wrote: See the postgresql documentation at: http://www.postgresql.org/docs/8.2/interactive/plpgsql-cursors.html -Original Message- Fro