Re: why does this select hang postgres??? - Mailing list pgsql-general

From Jeremy Hansen
Subject Re: why does this select hang postgres???
Date
Msg-id Pine.LNX.4.30.0108101438070.20351-100000@srv1.ecropolis.com
Whole thread Raw
In response to Re: why does this select hang postgres???  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: why does this select hang postgres???  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
On Fri, 10 Aug 2001, Bruce Momjian wrote:

> >
> > select * from env_info,summary,plat_info;
> >
> > Is my statement broken?  Is this not legal?  Postgres just sits there....
> >
> > My goal is to select everything from multiple tables with one sql
> > statement.
>
> You didn't join the tables.  This will join each row to every other row.
> This will take a long time.

Any tips on this syntax?  I'll go look at joins right now I guess :-)

-jeremy


--
salad.


pgsql-general by date:

Previous
From: "Steve Wolfe"
Date:
Subject: Re: why does this select hang postgres???
Next
From: Fran Fabrizio
Date:
Subject: Re: why does this select hang postgres???