Re: Fake table name? - Mailing list pgsql-general

From Roderick A. Anderson
Subject Re: Fake table name?
Date
Msg-id Pine.LNX.4.10.10010030723160.21546-100000@altoplanos.net
Whole thread Raw
In response to Re: Fake table name?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, 3 Oct 2000, Tom Lane wrote:

> "Roderick A. Anderson" <raanders@altoplanos.net> writes:
> >     select tbl_key, equipname from equipment
> >     UNION
> >     select 'All', 'All Equipment' from ???
>
> Postgres has a cleaner answer than a fake table; just omit the
> FROM clause:

As I discovered by RTFM.

Thanks for the confirmation.


Rod
--
Roderick A. Anderson
raanders@altoplanos.net               Altoplanos Information Systems, Inc.
Voice: 208.765.6149                            212 S. 11th Street, Suite 5
FAX: 208.664.5299                                  Coeur d'Alene, ID 83814


pgsql-general by date:

Previous
From: Nelson Ferreira Jr
Date:
Subject: Re: alternative DB locations
Next
From: "chris markiewicz"
Date:
Subject: RE: trouble with trigger/function???