limit?

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org>
Subject: limit?
Date: 2000-06-21 18:03:52
Message-ID: 20000621200352.A3236@fam-meskes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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!

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message D'Arcy J.M. Cain 2000-06-21 18:13:02 Re: Changes to functions and triggers
Previous Message Bruce Momjian 2000-06-21 17:05:39 Re: Big 7.1 open items