On Tue, 3 Oct 2000, Tom Lane wrote: > "Roderick A. Anderson" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] Altoplanos Information Systems, Inc. Voice: 208.765.6149 212 S. 11th Street, Suite 5 FAX: 208.664.5299 Coeur d'Alene, ID 83814
