[PHP-DB] pg_fetch_result returns something other than boolean???

[Matthew Newby]

I am having trouble with the pg_fetch_result function when trying to access
a boolean field in a PostgreSQL database.  Here's the code snippet:

$strField = "blnAllDayEvent";
$intFieldNum = pg_field_num($rsEvent,$strField);
echo "Field type for " . $strField . " is " .
pg_field_type($rsEvent,$intFieldNum);
echo " and the value is " . pg_fetch_result($rsEvent,$i,$strField);
if (pg_fetch_result($rsEvent,$i,$strField)) {
  echo " or TRUE";
} else {
  echo " or FALSE";
}
echo "<br/>";
$strField = "blnRecurringEvent";
$intFieldNum = pg_field_num($rsEvent,$strField);
echo "Field type for " . $strField . " is " .
pg_field_type($rsEvent,$intFieldNum);
echo " and the value is " . pg_fetch_result($rsEvent,$i,$strField);
if (pg_fetch_result($rsEvent,$i,$strField)) {
  echo " or TRUE";
} else {
  echo " or FALSE";
}

The displayed information is:

Field type for blnAllDayEvent is bool and the value is f or TRUE
Field type for blnRecurringEvent is bool and the value is t or TRUE

Obviously, 'f' is NOT true.  So, is this a bug or am I doing something
wrong?

I'm using PostgreSQL v7.2.1, PHP v4.2.1, on a FreeBSD 4.5-STABLE system.

-matt



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php