Re: referencing column names properly - Mailing list pgsql-sql

From Ross J. Reedstrom
Subject Re: referencing column names properly
Date
Msg-id 20030209225615.GA11550@wallace.ece.rice.edu
Whole thread Raw
In response to Re: referencing column names properly  ("Sill-II, Stephen" <Stephen.Sill-II@ost.dot.gov>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "A.M."
Date:
Subject: order by date desc but NULLs last
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: order by date desc but NULLs last