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(dot)Guzzetti(at)irpi(dot)pg(dot)cnr(dot)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(dot)Guzzetti(at)irpi(dot)pg(dot)cnr(dot)it
>