Re: PostgreSQL and case sensitivity
| From: | Jancs | Date: | Tue, 09 Oct 2001 07:44:11 +0000 |
| Subject: | Re: PostgreSQL and case sensitivity | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13137@lists.php.net to get a copy of this message | ||
At 11:13 01.10.08. -0500, you wrote:
Nither field names nor column names are case sensitive in Postgres so you don't have to worry about it.so then how you will explain the fact, that in case if the field names are, for example, ID_this and id_thar, you can't get anything with select ID_this from database and in the same time select id_that from database returns the values (selection). Is i change the field name to lower case, everything works fine. I observed this with Postgres 7.1.2 as well as running php script as from psql console. Janis Jancs Laps Cileecish http://jancs.ktf.rtu.lv