Re: [HACKERS] I cant find it or I'm just lazy ?

2003-03-07 Thread Darko Prenosil
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.

Re: [HACKERS] I cant find it or I'm just lazy ?

2003-03-07 Thread Bruce Momjian
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

Re: [HACKERS] I cant find it or I'm just lazy ?

2003-03-07 Thread Tom Lane
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

Re: [HACKERS] I cant find it or I'm just lazy ?

2003-02-26 Thread Darko Prenosil
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

Re: [HACKERS] I cant find it or I'm just lazy ?

2003-02-26 Thread Jeroen T. Vermeulen
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

Re: [HACKERS] I cant find it or I'm just lazy ?

2003-02-25 Thread Christoph Haller
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

Re: [HACKERS] I cant find it or I'm just lazy ?

2003-02-25 Thread Christoph Haller
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

Re: [HACKERS] I cant find it or I'm just lazy ?

2003-02-25 Thread Jeroen T. Vermeulen
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

Re: [HACKERS] I cant find it or I'm just lazy ?

2003-02-25 Thread Darko Prenosil
-- 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

Re: [HACKERS] I cant find it or I'm just lazy ?

2003-02-25 Thread Jeroen T. Vermeulen
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

Re: [HACKERS] I cant find it or I'm just lazy ?

2003-02-25 Thread Darko Prenosil
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

Re: [HACKERS] I cant find it or I'm just lazy ?

2003-02-25 Thread Jeroen T. Vermeulen
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

Re: [HACKERS] I cant find it or I'm just lazy ?

2003-02-25 Thread Christoph Haller
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

Re: [HACKERS] I cant find it or I'm just lazy ?

2003-02-25 Thread Darko Prenosil
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

[HACKERS] I cant find it or I'm just lazy ?

2003-02-24 Thread Darko Prenosil
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.