Re: why does this select hang postgres???

> 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 :-)

See chapter on joins:

    http://www.postgresql.org/docs/awbook.html

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026