Fields Case problem

From: Giuseppe Tanzilli - CSF <g(dot)tanzilli(at)gruppocsf(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Fields Case problem
Date: 2000-11-24 15:49:05
Message-ID: 3A1E8DF1.6020906@gruppocsf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-11-24 16:37:34 Re: [HACKERS] Enum type emulation: problem with opaque type in PL/pgSQL functions
Previous Message GH 2000-11-24 12:18:04 Re: Re: re : PHP and persistent connections