limit?

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(at)Fam-Meskes(dot)De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!