Is limit ignored in a cursor definition? I just was send a source that ecpg
seemed to have problems with:
...
EXEC SQL DECLARE H CURSOR FOR select id,name from ff order by id asc limit 2;
EXEC SQL OPEN H ;
while(1){
EXEC SQL FETCH IN H INTO :id,:name ;
printf("%d-%s\n",id,name.arr);
}
...
I never before tried this and one could easily program this functionality
wihtout limit, but I still wonder if it's correct that limit is ignored. BTW
I only tested it with 6.5.3.
Michael
--
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!