Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4U4LwE28496 for ; Wed, 30 May 2001 00:21:58 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f4U4LdR20800; Wed, 30 May 2001 00:21:39 -0400 (EDT) To: darcy@druid.net (D'Arcy J.M. Cain) cc: Phuong Ma , Postgres SQL Subject: Re: Shortcut? In-reply-to: <20010530011951.7BA4F1A91@druid.net> References: <20010530011951.7BA4F1A91@druid.net> Comments: In-reply-to darcy@druid.net (D'Arcy J.M. Cain) message dated "Tue, 29 May 2001 21:19:51 -0400" Date: Wed, 30 May 2001 00:21:38 -0400 Message-ID: <20797.991196498@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200105/324 X-Sequence-Number: 3165 darcy@druid.net (D'Arcy J.M. Cain) writes: > Thus spake Phuong Ma >> SELECT distributors.* WHERE name = 'Westwood'; >> I tried it on tables in our database, but it doesn't work. Is that part >> of earlier versions of Postgres? > I assume you mean this. > SELECT distributors.* WHERE distributors.name = 'Westwood'; Yes: you must mention a table in FROM to make its field names available for reference without qualification. I think we may have tightened that in recent releases --- the current political climate is to discourage use of tables without FROM, since SQL92 doesn't allow it at all. > Can you tell me where you found that example. I couldn't find it in the > documentation sources. A quick glimpse shows that we still have it in ref/select.sgml (try 'Westward' instead of 'Westwood'). Will fix. regards, tom lane