Re: [HACKERS] Case Preservation disregarding case

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: ken(at)kensystem(dot)com
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: Re: [HACKERS] Case Preservation disregarding case
Date: 2006-12-02 16:02:55
Message-ID: 4571A3AF.6070608@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthew T. O'Connor 2006-12-02 16:17:27 Re: PostgreSQL win32 fragmentation issue
Previous Message Ken Johanson 2006-12-02 15:21:08 Re: [HACKERS] Case Preservation disregarding case

Browse pgsql-sql by date

  From Date Subject
Next Message Ken Johanson 2006-12-02 16:48:38 Re: [HACKERS] Case Preservation disregarding case
Previous Message Ken Johanson 2006-12-02 15:21:08 Re: [HACKERS] Case Preservation disregarding case