Re: inner join

On Tue, Dec 05, 2000 at 03:21:02PM -0500, some SMTP stream spewed forth:
> "Romina N. Tulisi" <romina(at)spcom(dot)com(dot)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;

What are the reasons (other than useability ;-)) for using one rather
than the other?

Thanks.

gh

>
> JOIN syntax will work a lot better in 7.1.
>
> regards, tom lane