RE: MySQL file system

I believe "Number" should work, refer to the postgres Manual:
http://www.postgresql.org/docs/user/x524.htm
- Stuart
> -----Original Message-----
> From:	Fausto Guzzetti [SMTP:Fausto.Guzzetti@irpi.pg.cnr.it]
> Sent:	Wednesday, January 17, 2001 1:21 PM
> To:	PostgreSQL General
> Subject:	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.Guzzetti@irpi.pg.cnr.it
>