Re: inner join - Mailing list pgsql-novice

From Tom Lane
Subject Re: inner join
Date
Msg-id 23426.976047662@sss.pgh.pa.us
Whole thread Raw
In response to inner join  ("Romina N. Tulisi" <romina@spcom.com.ar>)
Responses Re: inner join  (GH <grasshacker@over-yonder.net>)
Re[2]: inner join  ("Romina N. Tulisi" <romina@spcom.com.ar>)
List pgsql-novice
"Romina N. Tulisi" <romina@spcom.com.ar> writes:
> I've been trying to do a natural inner join with postgresql. However,
> when I try to do that I loose my connection to the database.

The "inner join" syntax support in 7.0 is really just beta-quality
code; it's got a few bugs.  I'd suggest writing the query without
using inner join syntax, ie plain old
    SELECT ... FROM a,b WHERE a.x = b.x;

JOIN syntax will work a lot better in 7.1.

            regards, tom lane

pgsql-novice by date:

Previous
From: Mike Castle
Date:
Subject: Re: Transactions
Next
From: "Joel Burton"
Date:
Subject: Re: inner join