Re: Views

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@fuhr.org>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgre General" <pgsql-general@postgresql.org>
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