On Thursday 06 March 2003 19:08, Bruce Momjian wrote:
Jeroen T. Vermeulen wrote:
On Tue, Feb 25, 2003 at 02:04:50PM +0100, Christoph Haller wrote:
Anyway, you may MOVE until 0 instead of FETCH, or use the COUNT()
function on the query to learn about the number of rows to be returned.
I just tested the MOVE -5 in a simple case, and it worked:
test= begin;
BEGIN
test= declare xx cursor for select * from pg_class;
DECLARE CURSOR
test= move from xx;
MOVE 157
test= move -5 from xx;
MOVE 5
test= fetch
Bruce Momjian [EMAIL PROTECTED] writes:
What I think you are seeing are that certain cursors can't go backwards.
Lots of the more complex plan node types don't correctly implement
backwards fetch. I've looked briefly at fixing that, but it looks like
it'd be a major pain in the rear for some
On Tuesday 25 February 2003 18:57, Jeroen T. Vermeulen wrote:
On Tue, Feb 25, 2003 at 07:34:12PM +, Darko Prenosil wrote:
Unfortunately it is application written in QT library that should work on
Windows too, but I'll take a look, I'm sure I can learn something from it
!
Well, libpqxx
On Wed, Feb 26, 2003 at 09:44:14AM +, Darko Prenosil wrote:
I got the sources yesterday. Thank you !
Let me know whether everything works for you. There's also a mailing
list on pqxx.tk if you need it.
Jeroen
---(end of broadcast)---
TIP
How can I get information is TRANSACTION already started ?
I did not mean 'TRANSACTION ISOLATION LEVEL', but 'TRANSACTION LEVEL'
!
OK, it is bad construction - my fault !
What I meant is : IS-TRANSACTION-ALREADY-STARTED ?
I used 'TRANSACTION LEVEL' because I saw that Bruce is working on
On Tuesday 25 February 2003 09:28, Christoph Haller wrote:
On Mon, Feb 24, 2003 at 07:53:05PM +, Darko Prenosil wrote:
I need two answers I did not find in documentation :
How can I get exact number of rows in DECLARED CURSOR ?
OK, I can FETCH until NULL, but this does not
On Tue, Feb 25, 2003 at 02:04:50PM +0100, Christoph Haller wrote:
Anyway, you may MOVE until 0 instead of FETCH, or use the COUNT()
function on the query to learn about the number of rows to be returned.
Hmm... Wouldn't the reliability of a count() depend on the isolation
level?
OTOH the
-- Forwarded Message --
Subject: Re: [HACKERS] I cant find it or I'm just lazy ?
Date: Tue, 25 Feb 2003 17:51:13 +
From: Darko Prenosil [EMAIL PROTECTED]
To: Christoph Haller [EMAIL PROTECTED]
On Tuesday 25 February 2003 13:04, Christoph Haller wrote:
On Tuesday 25
On Tue, Feb 25, 2003 at 05:55:59PM +, Darko Prenosil wrote:
I am trying to create client buffer that will show only records that are
needed by application(visible). Data should be send to client in pages, not
all the data at once. The idea is not to query for data that are already
On Tuesday 25 February 2003 17:14, Jeroen T. Vermeulen wrote:
On Tue, Feb 25, 2003 at 05:55:59PM +, Darko Prenosil wrote:
I am trying to create client buffer that will show only records that are
needed by application(visible). Data should be send to client in pages,
not all the data
On Tue, Feb 25, 2003 at 07:34:12PM +, Darko Prenosil wrote:
Unfortunately it is application written in QT library that should work on
Windows too, but I'll take a look, I'm sure I can learn something from it !
Well, libpqxx also runs on Windows but it takes a decent compiler (e.g.
Visual
On Mon, Feb 24, 2003 at 07:53:05PM +, Darko Prenosil wrote:
I need two answers I did not find in documentation :
How can I get exact number of rows in DECLARED CURSOR ?
OK, I can FETCH until NULL, but this does not fits my needs !
You may want to use FETCH ALL, otherwise what or
On Tuesday 25 February 2003 09:28, Christoph Haller wrote:
On Mon, Feb 24, 2003 at 07:53:05PM +, Darko Prenosil wrote:
I need two answers I did not find in documentation :
How can I get exact number of rows in DECLARED CURSOR ?
OK, I can FETCH until NULL, but this does not fits
I need two answers I did not find in documentation :
How can I get exact number of rows in DECLARED CURSOR ?
OK, I can FETCH until NULL, but this does not fits my needs !
How can I get information is TRANSACTION already started ?
(TRANSACTION LEVEL)
The interface I'm using is libpq.
15 matches
Mail list logo