Обсуждение: inner join

hello

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.

Anybody had this same problem and knows how to fix it? Or at least
have somebody found a work around?

Thanks

--
 Romina                          mailto:romina@spcom.com.ar
 Soluciones Punto Com
 http://www.spcom.com.ar

"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

> 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.
>
> Anybody had this same problem and knows how to fix it? Or at least
> have somebody found a work around?

Can you post a sample (w/CREATE TABLE, INSERT data, and
SELECT statements.) This will help us debug the problem.


--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)

On Tue, Dec 05, 2000 at 03:21:02PM -0500, some SMTP stream spewed forth:
> "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;

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

Is there reason for this function to hang?

Sandeep

Thanks to everyone for your answers. It was very helpful! I ended up
doing it like Tom said.

Thanks again,

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

TL> JOIN syntax will work a lot better in 7.1.

TL>                         regards, tom lane

--
Saludos,
 Romina N. Tulisi                            mailto:romina@spcom.com.ar
 Programmer
 Soluciones Punto Com S.A.
 http://www.spcom.com.ar