"Yasuo Ohgaki" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Matthew Newby wrote: > > 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: > > It's a spec. > > PostgresSQL's boolean is returned as 't' or 'f' and both are string. > Test as string. > > -- > Yasuo Ohgaki
Yasuo, Many thanks for the info. I "discovered" that test yesterday. However, if that is indeed the way I should test it, then something probably needs to change in the PHP docs. On the page http://www.php.net/manual/en/function.pg-fetch-result.php it explicitly states: "PostgreSQL has many built in types and only the basic ones are directly supported here. All forms of integer, boolean and void types are returned as integer values. All forms of float, and real types are returned as float values. All other types, including arrays are returned as strings formatted in the same default PostgreSQL manner that you would see in the psql program." However, it appears that booleans are NOT returned as integer types, but rather as single character 't' or 'f', at least as far as PHP is concerned. Thanks! -matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php