From: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
---|---|
To: | Michael Fuhr <mike(at)fuhr(dot)org> |
Cc: | Postgre General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Views |
Date: | 2005-12-18 22:52:23 |
Message-ID: | 00e101c60425$b62e5a70$ac1d4318@OWNER |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)fuhr(dot)org>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "Postgre General" <pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-12-19 00:49:45 | Re: Views |
Previous Message | stig erikson | 2005-12-18 20:03:39 | synchronization of news.postgresql.org and news.fr.postgresql.org |