On Fri, Apr 10, 2009 at 11:46 AM, Miłosz Tylenda <[email protected]> wrote:
> Hi Daryl, > > Are you sure your native query is what you want? In case I wasn't clear, the "native query" is not part of the code I'm running, but just something I'm running in a sql console to double-check things. > There might be some caveats with join precedence. No idea which database > you run against but to take an example, MySQL has the following: I'm running PostgreSQL. I admit I'm a little confused because there are no commas in the from table clause. I never use that approach, preferring explicit joins. As well, the data returned from the query agrees with the data imported from a text file and the variation run with the fetch plan commented out. So, yeah, I'm sure. -- Daryl Stultz _____________________________________ 6 Degrees Software and Consulting, Inc. http://www.6degrees.com mailto:[email protected]
