On Wed, Jan 17, 2001 at 02:21:01PM +0100, Fausto Guzzetti wrote:
>
> 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?
Try:
select * from avi_f_amm where "Number" > 1;
Cheers,
Patrick