Re: inner join

"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