Fields Case problem

Поиск
Список
Период
Сортировка
От Giuseppe Tanzilli - CSF
Тема Fields Case problem
Дата
Msg-id 3A1E8DF1.6020906@gruppocsf.com
обсуждение исходный текст
Список pgsql-hackers
Hi,

I had a problem porting applications from mySQL.
I can't find info on this in the docs... so mailed the list, sorry for 
my english.

I create the fileds name with first letter uppercase, I need this way, 
because the result set must have the fileds name with the correct case 
in PHP.

I would like to be able to do a  select wich is not case sensitive on 
the field name.

for example:

Create table test ("CodUtente");

select CodUtente from test;
select codutente from test;

on the current tree I got errors on the two select ,
only 
select "CodUtente" from test
will  work.


How ca i solve this problem ??
I can't rewrite all the query.
There is a patch somewhere to make pgsql really case insensitive (also 
in this strange case)?


thanks in advance

Giuseppe Tanzilli




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Max Fonin
Дата:
Сообщение: Re: Enum type emulation: problem with opaque type in PL/pgSQL functions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Enum type emulation: problem with opaque type in PL/pgSQL functions