pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Dennis Bjorklund <db@zigo.dhs.org>
To: ken@kensystem.com
Cc: Martijn van Oosterhout <kleptog@svana.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: [HACKERS] Case Preservation disregarding case
Date: Sat, 02 Dec 2006 17:02:55 +0100
Message-ID: <4571A3AF.6070608@zigo.dhs.org> (raw)
In-Reply-To: <457199E4.3010401@kensystem.com>
References: <200610271623.37525.beauh@bluefrogmobile.com>
	<1162003132.687.8.camel@pampa>
	<200610301928.51255.beauh@bluefrogmobile.com>
	<23177.1162265010@sss.pgh.pa.us>
	<EB48EBF3B239E948AC1E3F3780CF8F88012F88DD@MI8NYCMAIL02.Mi8.com>
	<45712E31.1030004@kensystem.com>
	<20061202133556.GC26365@svana.org>
	<457199E4.3010401@kensystem.com>

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



view thread (29+ messages)  latest in thread

Message-ID: <4571A3AF.6070608@zigo.dhs.org>
Permalink:  ../4571A3AF.6070608@zigo.dhs.org/
Also on:    postgresql.org/message-id/4571A3AF.6070608@zigo.dhs.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: db@zigo.dhs.org, ken@kensystem.com, kleptog@svana.org
  Subject: Re: [HACKERS] Case Preservation disregarding case
  In-Reply-To: <4571A3AF.6070608@zigo.dhs.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox