... - Mailing list pgsql-admin

From Денис Осадчий
Subject ...
Date
Msg-id 5742.000721@turbo.nsk.su
Whole thread Raw
List 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.



pgsql-admin by date:

Previous
From: Magnus Hagander
Date:
Subject: RE: MS Access out-performs PostgreSQL 7?
Next
From: "Paulo Roberto Siqueira"
Date:
Subject: RES: MS Access out-performs PostgreSQL 7?