From: Денис Осадчий <osadchy(at)turbo(dot)nsk(dot)su>
To: pgsql-admin(at)postgresql(dot)org
Subject:
Date: 2000-07-21 11:48:38
Message-ID: 5742.000721@turbo.nsk.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Browse pgsql-admin by date

  From Date Subject
Next Message Paulo Roberto Siqueira 2000-07-21 14:15:02 RES: MS Access out-performs PostgreSQL 7?
Previous Message Magnus Hagander 2000-07-21 07:23:22 RE: MS Access out-performs PostgreSQL 7?