Re: Views
От | Bob Pawley |
---|---|
Тема | Re: Views |
Дата | |
Msg-id | 00e101c60425$b62e5a70$ac1d4318@OWNER обсуждение исходный текст |
Ответ на | Views (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: Views
|
Список | 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@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
В списке pgsql-general по дате отправления: