Re: MySQL file system

Hello,

I have what I think is a trivial problem. But I wasn't able to find a solution
in the FAQ or in the docs I have.

It has to do with case sensitivity. I am working with an application of
PostrreSQL (7.02) and PHP4.

My table name is (for example) avi_f_amm and contains a field named Number
(capital N)

The query select * from avi_f_amm works fine.
The query select * from avi_f_amm where Number gt 1 does not because number
(small cap n) is to a field in the table.
In other words Postgresql does not recognize "Number" and thinks it is "number"

Any idea of what is going on or where should I look in the documentation?

Fausto

--
Fausto Guzzetti
CNR - IRPI Perugia
via della Madonna Alta, 126
06128 PERUGIA (Italy)
Tel. +39 075.505.4943
Fax. +39 075.505.1325
E.mail F(dot)Guzzetti(at)irpi(dot)pg(dot)cnr(dot)it