Thread: ...

...

From
Денис Осадчий
Date:
Hello,
I try to select rows with LIMIT statement:
select NICO, NICO, InDate from FirmICO LIMIT 5 OFFSET 5;
- It works correctly.
But when i try aply this query to declare cursor, it returns me all rows:
DECLARE scursor CURSOR FOR select NICO, NICO, InDate from FirmICO
LIMIT 5 OFFSET 5;

Why it happends?
My be it important: i try declare cursor in C program, using LIBPQ programming
interface.