Received: from crazypenguins.commandprompt.com (dsl081-185-190.sea1.dsl.speakeasy.net [64.81.185.190]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4U05DE52004 for ; Tue, 29 May 2001 20:05:13 -0400 (EDT) (envelope-from pma@commandprompt.com) Received: from commandprompt.com (filesrv.commandprompt.com [192.168.1.35]) by crazypenguins.commandprompt.com (8.9.3/8.9.3) with ESMTP id RAA14269 for ; Tue, 29 May 2001 17:05:08 -0700 Message-ID: <3B14392D.C46B7B9B@commandprompt.com> Date: Tue, 29 May 2001 17:05:01 -0700 From: Phuong Ma X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.3-20mdk i586) X-Accept-Language: en MIME-Version: 1.0 To: Postgres SQL Subject: Shortcut? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200105/321 X-Sequence-Number: 3162 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? Thanks