Re: [HACKERS] Case Preservation disregarding case - Mailing list pgsql-sql

From Dennis Bjorklund
Subject Re: [HACKERS] Case Preservation disregarding case
Date
Msg-id 4571A3AF.6070608@zigo.dhs.org
Whole thread Raw
In response to Re: [HACKERS] Case Preservation disregarding case  (Ken Johanson <pg-user@kensystem.com>)
Responses Re: [HACKERS] Case Preservation disregarding case  (Ken Johanson <pg-user@kensystem.com>)
List pgsql-sql
Ken Johanson skrev:

> Has your experience with PG been different? If so I presume you have 
> have found a config that allows?:
> 
> SELECT
> pers.firstName,
> pers.lastname,

As long as you don't create the columns using quotes you can use that 
kind of names. For example
  CREATE TABLE foo (BAR int);
  INSERT INTO foo VALUES (42);
  SELECT BaR, bar, BAR, "bar" FROM foo;

But using "Bar" wont work.

/Dennis


pgsql-sql by date:

Previous
From: Ken Johanson
Date:
Subject: Re: [HACKERS] Case Preservation disregarding case
Next
From: Ken Johanson
Date:
Subject: Re: [HACKERS] Case Preservation disregarding case