Postgres Pro
Downloads
Home   >   mailing lists

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

From Fernando Schapachnik
Subject Re: why does this select hang postgres???
Date
Msg-id 20010810150556.B20415@ns1.via-net-works.net.ar
Whole thread Raw
In response to why does this select hang postgres???  (Jeremy Hansen <jeremy@xxedgexx.com>)
List pgsql-general
Tree view 
En un mensaje anterior, Jeremy Hansen escribió:
>
> select * from env_info,summary,plat_info;
>
> Is my statement broken?  Is this not legal?  Postgres just sits there....

It is legal, but has another semantics. It doesn't mean union, but
product. You will be get every combination of env_info, summary and
plat_info records.

Regards.



Fernando P. Schapachnik
Planificación de red y tecnología
VIA NET.WORKS ARGENTINA S.A.
fschapachnik@vianetworks.com.ar
Tel.: (54-11) 4323-3381

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: why does this select hang postgres???
Next
From: "Joe Conway"
Date:
Subject: Re: why does this select hang postgres???