Return-Path: owner-postman Delivery-Date: Mon, 24 Jan 94 05:23:41 -0800 Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id FAA09483 for postgres-list; Mon, 24 Jan 1994 05:23:23 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199401241323.FAA09483@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from eng.ie.cuhk.hk (eng.ie.cuhk.hk [137.189.98.200]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id FAA09474 for ; Mon, 24 Jan 1994 05:23:19 -0800 From: shlam@ie.cuhk.hk Received: by eng.ie.cuhk.hk (5.57/Ultrix3.0-C) id AA16076; Mon, 24 Jan 94 21:25:07 +0800 Message-Id: <9401241325.AA16076@eng.ie.cuhk.hk> To: postgres@postgres.Berkeley.EDU Subject: Help. Hidden information during query without filter Date: Mon, 24 Jan 94 21:25:06 +0800 Resent-To: postgres-list@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Mon, 24 Jan 94 05:23:23 -0800 Resent-XMts: smtp We have a table of about 1500 records size. We discovered that when we query the table without any filter, it gives us ~ 160 records. However, when we query the table with each filter separately, it gives us the total 1500 records as we add up the individual query all together. Is there any problem of some kind of buffer overflow? We did not encounter this problem when the size of the table was small. I will be very appreciate it if you can give me some clue to solve this problem. Thanks. Alan S. H. Lam Department of Information Engineering, CUHK, Hong Kong E-mail: shlam@ie.cuhk.hk Tel: (852) 609 8364 Fax: (852) 603 5032