Michael
That worked fine.
Thanks for the help. Could you point me to some documentation on the use of
parentheses? Perhaps something that describes what action the parentheses
accomplishes?
Bob
----- Original Message -----
From: "Michael Fuhr" <mike@xxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Postgre General" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Saturday, December 17, 2005 4:09 PM
Subject: Re: [GENERAL] Views
On Sat, Dec 17, 2005 at 03:39:02PM -0800, Bob Pawley wrote:
The following gives me the information, but the rows are duplicated
from one to three times. I would like to see one row for each of the
values. I have attempted a number of variations but they all give me
similar duplication.
Is this duplication due to the action of postgre as to the information
I've entered into the tables , or is it due to the structure of the
command?
Have you tried using parentheses to group the OR expressions in the
WHERE clause?
where (devices.type_ = 'monitor' or devices.type_ = 'valve')
and devices.fluid_id = process.fluid_id;
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
