Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.1/8.9.1) with ESMTP id OAA29243 for ; Wed, 6 Jan 1999 14:30:39 -0500 (EST) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id NAA24745; Wed, 6 Jan 1999 13:30:36 -0600 (CST) Received: from cpsmail.cpsgroup.com(144.210.12.11) by gauntlet.bjke.com via smap (4.1) id xmab23790; Wed, 6 Jan 99 13:29:51 -0600 Received: by cpsmail with Internet Mail Service (5.0.1458.49) id ; Wed, 6 Jan 1999 13:32:28 -0600 Message-ID: From: "Jackson, DeJuan" To: Bruce Momjian , fmorton@base2inc.com Cc: pgsql-sql@postgreSQL.org Subject: RE: [SQL] Kind of Funny Date: Wed, 6 Jan 1999 13:32:27 -0600 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1458.49) Content-Type: text/plain > > Not thinking, as I often tend to do, I created a table named "order" > > and was confused to find the following query does not work: > > > > select * from order; > > > > I recognize that my name selection is questionable, but shouldn't > > this still work? > > No. Keywords are not over-loadable, as they are in Pascal, > and to do it > is a real pain because the parser can't determine right away > what it is. But you can get at it if you quote your table name: select * from "order"; -DEJ