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.


  • ... Eric T. Jorgensen
  • ... mfarias
  • ... Jeremy G Byrne
  • ... Vladimir V. Zolotych
    • ... Rainer Mager
  • ... Daniel Kern
  • ... Andrei N.Sobchuck
  • ... Gagan
  • ... Gagan
  • ... Irfan Qaiser
  • ... Денис Осадчий
  • ... Денис Осадчий
  • ... Tim Frank
  • ... Dr. Hans-Christian Waldmann
  • ... Dr. Hans-Christian Waldmann
  • ... turing2000
  • ... turing2000
    • ... Michael Miyabara-McCaskey
  • ... Christian Pauchard
  • ... Williams Pedrogan

Reply via email to