From: [EMAIL PROTECTED]
Operating system: Redhat Linux 7.0
PHP version: 4.0.4pl1
PHP Bug Type: PostgreSQL related
Bug description: Case Sensitive Associative Arrays
The scenario is described here:
mydb=> CREATE TABLE test ( U_Name char(50), U_Pass char(16) );
mydb=> INSERT INTO test values ('Bob', 'password');
query.php:
<?
$conn = pg_connect("dbname=mydb");
$result = pg_exec($conn, "select U_Name, U_Pass from test")
$arr = pg_fetch_array($result, 0);
echo "U_Name: " + $arr[U_Name] + " U_Pass: " + $arr[U_Pass] + "<BR>";
echo "u_name: " + $arr[u_name] + " u_pass: " + $arr[u_pass] + "<BR>";
?>
results that are printed:U_Name: U_Pass:
u_name: Bob u_pass: password
( arr[0] = Bob, arr[1] = password)
U_Name is not being automatically lowercased when using associative arrays. As of
v6.1 PostgreSQL lowercases all table names as well as all columns. So searching on
mixed case or uppercase names will not work unless they are enclosed in quotes..
--
Edit Bug report at: http://bugs.php.net/?id=10121&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
