Received: from druid.net (druid.net [216.126.72.98]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4U1JkE72488 for ; Tue, 29 May 2001 21:19:46 -0400 (EDT) (envelope-from darcy@druid.net) Received: by druid.net (Postfix, from userid 1000) id 7BA4F1A91; Tue, 29 May 2001 21:19:51 -0400 (EDT) Subject: Re: Shortcut? In-Reply-To: <3B14392D.C46B7B9B@commandprompt.com> "from Phuong Ma at May 29, 2001 05:05:01 pm" To: Phuong Ma Date: Tue, 29 May 2001 21:19:51 -0400 (EDT) Cc: Postgres SQL X-Mailer: ELM [version 2.4ME+ PL78 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII Message-Id: <20010530011951.7BA4F1A91@druid.net> From: darcy@druid.net (D'Arcy J.M. Cain) X-Archive-Number: 200105/323 X-Sequence-Number: 3164 Thus spake Phuong Ma > I'm running Postgres 7.1. I read in the documentation that the from > clause can be omitted from a select statement. The example given in the > documentation is: > 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'; I know that this example from my own database works. devel=# SELECT country.country_name devel-# WHERE country.country_id = province.country_id AND devel-# province.prov = 'ON'; country_name -------------- Canada (1 row) Can you tell me where you found that example. I couldn't find it in the documentation sources. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.