From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Jeremy Hansen <jeremy(at)xxedgexx(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: why does this select hang postgres??? |
Date: | 2001-08-10 18:42:59 |
Message-ID: | 200108101842.f7AIgx625300@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 :-)
See chapter on joins:
http://www.postgresql.org/docs/awbook.html
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Shraibman | 2001-08-10 18:49:12 | Re: why does this select hang postgres??? |
Previous Message | Joe Conway | 2001-08-10 18:38:54 | Re: why does this select hang postgres??? |