From: | Tom Werges <djosephs(at)citiscape(dot)com> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Bug? |
Date: | 1999-03-07 23:54:25 |
Message-ID: | 99030800103406.08438@cartman.citiscape.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter L. Berghold | 1999-03-08 02:06:24 | Visual Basic via ODBC? |
Previous Message | James Thompson | 1999-03-07 23:44:05 | Odd program behaviour |