Req #78855 [Com]: Native PHP types in database fetches

Edit report at https://bugs.php.net/bug.php?id=78855&edit=1 ID: 78855 Comment by: olegxx at gmail dot com Reported by: olegxx at gmail dot com Summary: Native PHP types in database fetches Status: Open Type: Feature/Change Request Package: PostgreSQL related Operating System: Linux PHP Version: 7.2.25 Block user comment: N Private report: N New Comment: PostgreSQL have bool type: $res = pg_query($db, "SELECT false"); var_dump(pg_fetch_result($res, 0)); This code should print "bool(false)" in native types mode but "FALSE is returned if row exceeds the number of rows in the set, or on any other error." Previous Comments: ------------------------------------------------------------------------ [2019-11-22 12:24:49] imbolk at gmail dot com MySQL does not have a Boolean type, and Postgres does. ------------------------------------------------------------------------ [2019-11-22 12:23:41] fgfgfgfdf at somewhere dot com > This extension do not have any connection wide options cool, than introduce pg_options() is the right thing to do for the sake of cosistency and usability either i have a strict typed project or not and seek and adjust every single line containing pg_ don't scale at any moment, in a existing codebase nobody would do that and later you can be sure people forget to use the option here and there which is not funny when you get strings instead int on random places ------------------------------------------------------------------------ [2019-11-22 12:19:31] imbolk at gmail dot com Of course I understand that. I don't think you understand what I mean. Now pg_fetch_result returns FALSE on the error. If they do as you suggest, it will return FALSE on the error and FALSE if it need to return the boolean value of FALSE, which came from the database. ------------------------------------------------------------------------ [2019-11-22 12:14:00] olegxx at gmail dot com This extension do not have any connection wide options. The problem with pg_fetch_result is that it cannot return false as valid result because it return false is case of an error. ------------------------------------------------------------------------ [2019-11-22 11:35:36] fgfgfgfdf at somewhere dot com didn't you get the point? it has to be *connection wide* option and it shouldn't be completly different for each and every database type mysqli_init() -> mysqli_options() -> mysqli_real_connect() ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=78855 -- Edit this bug report at https://bugs.php.net/bug.php?id=78855&edit=1