Bug? - Mailing list pgsql-general

From Tom Werges
Subject Bug?
Date
Msg-id 99030800103406.08438@cartman.citiscape.com
Whole thread Raw
List pgsql-general
When I execute the following query:

"select p.id, s.name from phys p, phys_spec s where p.r_phys_spec = s.id and
p.r_phys_spec > 0"

.... it returns nothing. However if I add " AND p.id=585" to the end of that
query, it returns _one result_.

How is that possible? Add an extra condition and get back more results? The
second query logically must return a set equal to or smaller than the second.

Am I missing something? What does a person generally do in a situation like
this?

Background : v 6.4.2, downloaded and compiled like 4 days ago, on Red Hat 5.2
w/ gcc 2.7.2.

TIA
tom

pgsql-general by date:

Previous
From: "Albert Chen"
Date:
Subject: The *good* Chinese info regarding porting Postgres to NT
Next
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] Updatable views?