Re: [HACKERS] Case Preservation disregarding case

Поиск
Список
Период
Сортировка
Искать
От
Dennis Bjorklund
Тема
Re: [HACKERS] Case Preservation disregarding case
Дата
Msg-id
4571A3AF.6070608@zigo.dhs.org
Ответ на
Список
Дерево обсуждения
Re: [HACKERS] Case Preservation disregarding case "Chuck McDevitt" <cmcdevitt@greenplum.com>
Re: [HACKERS] Case Preservation disregarding case "Simon Riggs" <simon@2ndquadrant.com>
Re: [HACKERS] Case Preservation disregarding case Tom Lane <tgl@sss.pgh.pa.us>
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 по дате отправления
От: Ken Johanson
Дата:
От: Ken Johanson
Дата:
FAQ