Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id NAA06459 for postgres-redist; Thu, 18 Aug 1994 13:09:36 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199408182009.NAA06459@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from von-neumann.info.polymtl.ca (von-neumann.info.polymtl.ca [132.207.4.4]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id NAA06449 for <postgres@nobozo.CS.Berkeley.EDU>; Thu, 18 Aug 1994 13:09:35 -0700
Received: from de-morgan.info.polymtl.ca by von-neumann.info.polymtl.ca with SMTP id AA03624
  (5.65c/IDA-1.4.4 for <postgres@nobozo.CS.Berkeley.EDU>); Thu, 18 Aug 1994 16:09:27 -0400
Received: by de-morgan.info.polymtl.ca (4.1/SMI-4.1)
	id AA04328; Thu, 18 Aug 94 16:09:25 EDT
Date: Thu, 18 Aug 1994 16:09:24 -0400 (EDT)
From: Guy Dupont <dupont@info.polymtl.ca>
Subject: moving in a portal
To: postgres@postgres.Berkeley.EDU
Message-Id: <Pine.3.89.9408181647.D4317-0100000@de-morgan>
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Thu, 18 Aug 94 13:09:36 -0700
Resent-XMts: smtp

I have some problems with the command fetch. 

I want to count the number of instance in my portal.  

So I make a first fetch to go to the last instances and get the number 
of instance.  But if I fetch backward to return to the beginning of the 
portal, i get nothing and all other fetch in one or the other direction 
will return nothing.  I join an example of it.

It seems to me that there is a problem when an extremite of the portal 
is get.

Can somebody has experienced a similar problem ?

Thank Guy,

Here is the example:


Welcome to the POSTGRES terminal monitor

Go 
* 
Query sent to backend is "begin "
BEGIN
Go 
* 
Query sent to backend is "retrieve portal myportal (pg_user.usename) "
RETRIEVE
Go 
* 
Query sent to backend is "fetch all in myportal "
---------------
| usename     |
---------------
| postgres    |
---------------
| nouveau     |
---------------
| pfeadm      |
---------------
| dupont      |
---------------

Go 

--> It's ok until now but:

* 
Query sent to backend is "fetch backward all in myportal "
---------------
| usename     |
---------------

--> I get nothing evan when I want to return to the begining.
Go 
* 
Query sent to backend is "fetch all in myportal "
---------------
| usename     |
---------------

--> still nothing
Go 
* 
Query sent to backend is "fetch backward all in myportal "
---------------
| usename     |
---------------

Go 
* 
Query sent to backend is "end "
END
Go 
* 







==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================