X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B09C0474E5C for ; Sun, 9 Feb 2003 17:56:16 -0500 (EST) Received: from ece.rice.edu (ece.rice.edu [128.42.4.34]) by postgresql.org (Postfix) with ESMTP id 40E80474E53 for ; Sun, 9 Feb 2003 17:56:16 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by ece.rice.edu (Postfix) with SMTP id 8B51268AA8; Sun, 9 Feb 2003 16:56:18 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by ece.rice.edu (Postfix) with ESMTP id 3DCBB68A7B; Sun, 9 Feb 2003 16:56:18 -0600 (CST) Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by ece.rice.edu (Postfix) with ESMTP id 8F98D68A5B; Sun, 9 Feb 2003 16:56:16 -0600 (CST) Received: from reedstrm by wallace.ece.rice.edu with local (Exim 3.36 #1 (Debian)) id 18i0Mx-00036X-00; Sun, 09 Feb 2003 16:56:15 -0600 Date: Sun, 9 Feb 2003 16:56:15 -0600 From: "Ross J. Reedstrom" To: "Sill-II, Stephen" Cc: "''pgsql-sql@postgresql.org' '" Subject: Re: referencing column names properly Message-ID: <20030209225615.GA11550@wallace.ece.rice.edu> Mail-Followup-To: "Ross J. Reedstrom" , "Sill-II, Stephen" , "''pgsql-sql@postgresql.org' '" References: <4BAE87828F06EB45B2641B83D370350F45E5@ostex002.ad.ost.dot.gov> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4BAE87828F06EB45B2641B83D370350F45E5@ostex002.ad.ost.dot.gov> User-Agent: Mutt/1.4i X-Virus-Scanned: by AMaViS snapshot-20020300 X-DCC--Metrics: ece.rice.edu 1066; Body=1 Fuz1=1 Fuz2=1 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/180 X-Sequence-Number: 11578 On Sun, Feb 09, 2003 at 09:18:05AM -0500, Sill-II, Stephen wrote: > Thanks much! After much experimentation, I figured it out. I remember > reading in the postgres oreily book that if you don't quote the identifiers, > that it converts them all to lowercase for processing. Does the dash in the > name also require the name to be quoted? Yup, so the expression parser can differentiate between a-b (column"a" - column "b") and a-b (column named "a-b"). Ross