Re: referencing column names properly

From: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
To: "Sill-II, Stephen" <Stephen(dot)Sill-II(at)ost(dot)dot(dot)gov>
Cc: "''pgsql-sql(at)postgresql(dot)org' '" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: referencing column names properly
Date: 2003-02-09 22:56:15
Message-ID: 20030209225615.GA11550@wallace.ece.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ross J. Reedstrom 2003-02-09 23:12:04 Re: order by date desc but NULLs last
Previous Message A.M. 2003-02-09 22:29:29 order by date desc but NULLs last