RE: MySQL file system
От | Henshall, Stuart - WCP |
---|---|
Тема | RE: MySQL file system |
Дата | |
Msg-id | E2870D8CE1CCD311BAF50008C71EDE8E014C63DB@MAIL_EXCHANGE обсуждение исходный текст |
Ответ на | MySQL file system (Ned Lilly <ned@greatbridge.com>) |
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: