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 SAA29640 for postgres-redist; Tue, 4 Oct 1994 18:11:40 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199410050111.SAA29640@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 EIGER.EDRC.CMU.EDU (EIGER.EDRC.CMU.EDU [128.2.214.41]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id SAA29630 for <postgres@nobozo.CS.Berkeley.EDU>; Tue, 4 Oct 1994 18:11:38 -0700
Received: from Messages.8.5.N.CUILIB.3.45.SNAP.NOT.LINKED.EIGER.EDRC.CMU.EDU.pmax.mach
          via MS.5.6.EIGER.EDRC.CMU.EDU.pmax_mach;
          Tue,  4 Oct 1994 21:10:52 -0400 (EDT)
Message-ID: <AiYToQS00hMd8UgK4N@cs.cmu.edu>
Date: Tue,  4 Oct 1994 21:10:52 -0400 (EDT)
From: Robert.Patrick@cs.cmu.edu
To: postgres@postgres.Berkeley.EDU
Subject: Limit to where clause length???????
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Tue, 04 Oct 94 18:11:40 -0700
Resent-XMts: smtp

I am attempting to execute a query over several tables by stringing
together a where clause that match the correct attributes in each of
four tables.  

If I execute the following query, I get back a 10 tuples.

retrieve (models.all) where langLinks.source = models.id
	and langLinks.title = "Universal"

However, when I execute the following query, I get back an empty table.

retrieve (model.all) where (lang.Links.source = models.id 
	and langLinks.title = "Universal") or 
	(partLinks.source = models.id and partLinks.title = "Universal") or
	(userLinks.source = models.id and userLinks.title = "Universal") or
	(opLinks.source = models.id and opLinks.title = "Universal")

Why doesn't this query find the same tuples the first one finds?

Thanks,
Robert

==============================================================================
   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.
==============================================================================