Re: OR problems - Mailing list pgsql-general

From tony
Subject Re: OR problems
Date
Msg-id 1016823379.8711.122.camel@vaio
Whole thread Raw
In response to Re: OR problems  (Jean-Luc Lachance <jllachan@nsd.ca>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Huge Performance Difference on Similar Query in Pg7.2
Next
From: "Joel Burton"
Date:
Subject: initdb dies during IpcSemaphoreCreate under BSD jail