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
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 |