| 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: | Whole Thread | Raw Message | 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 |