Re: OR problems

Поиск
Список
Период
Сортировка
От tony
Тема Re: OR problems
Дата
Msg-id 1016823379.8711.122.camel@vaio
обсуждение исходный текст
Ответ на Re: OR problems  (Jean-Luc Lachance <jllachan@nsd.ca>)
Список pgsql-general
On Fri, 2002-03-22 at 19:54, Jean-Luc Lachance wrote:

> The problem is not with the OR or the DISTINCT ON.
> You are requesting a cartesian product ot three tables.
> You should have a JOIN ON or a proper WHERE clause.

OK thanks. I thougth that was it

fonction is the joining table for individu and structure.

Ta

Tony

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Huge Performance Difference on Similar Query in Pg7.2
Следующее
От: "Joel Burton"
Дата:
Сообщение: initdb dies during IpcSemaphoreCreate under BSD jail