+#define PHP_PQRES_JSON_OPTIONS(res) \
+ (php_pqres_fetch_type(res) != PHP_PQRES_FETCH_OBJECT ? PHP_JSON_OBJECT_AS_ARRAY:0)
+
+zval *php_pqres_typed_zval(php_pqres_t *res, char *val, size_t len, Oid typ TSRMLS_DC)
+{
+ zval *zv, **zconv;
+
+ MAKE_STD_ZVAL(zv);
+
+ if (SUCCESS == zend_hash_index_find(&res->converters, typ, (void *) &zconv)) {
+ zval *ztype, *tmp = NULL;
+
+ MAKE_STD_ZVAL(ztype);
+ ZVAL_LONG(ztype, typ);
+ ZVAL_STRINGL(zv, val, len, 1);
+ zend_call_method_with_2_params(zconv, NULL, NULL, "convertfromstring", &tmp, zv, ztype);
+ zval_ptr_dtor(&ztype);
+
+ if (tmp) {
+ zval_ptr_dtor(&zv);
+ zv = tmp;
+ }
+
+ return zv;
+ }
+
+ switch (typ) {
+ case PHP_PQ_OID_BOOL:
+ if (!(res->auto_convert & PHP_PQRES_CONV_BOOL)) {
+ goto noconversion;
+ }
+ ZVAL_BOOL(zv, *val == 't');
+ break;
+
+ case PHP_PQ_OID_INT8:
+ case PHP_PQ_OID_TID:
+ case PHP_PQ_OID_INT4:
+ case PHP_PQ_OID_INT2:
+ case PHP_PQ_OID_XID:
+ case PHP_PQ_OID_OID:
+ if (!(res->auto_convert & PHP_PQRES_CONV_INT)) {
+ goto noconversion;
+ }
+ {
+ long lval;
+ double dval;
+
+ switch (is_numeric_string(val, len, &lval, &dval, 0)) {
+ case IS_LONG:
+ ZVAL_LONG(zv, lval);
+ break;
+ case IS_DOUBLE:
+ ZVAL_DOUBLE(zv, dval);
+ break;
+ default:
+ goto noconversion;
+ }
+ }
+ break;
+
+ case PHP_PQ_OID_FLOAT4:
+ case PHP_PQ_OID_FLOAT8:
+ if (!(res->auto_convert & PHP_PQRES_CONV_FLOAT)) {
+ goto noconversion;
+ }
+ ZVAL_DOUBLE(zv, zend_strtod(val, NULL));
+ break;
+
+ case PHP_PQ_OID_DATE:
+ if (!(res->auto_convert & PHP_PQRES_CONV_DATETIME)) {
+ goto noconversion;
+ }
+ php_pqdt_from_string(zv, NULL, val, len, "Y-m-d", NULL TSRMLS_CC);
+ break;
+
+ case PHP_PQ_OID_ABSTIME:
+ if (!(res->auto_convert & PHP_PQRES_CONV_DATETIME)) {
+ goto noconversion;
+ }
+ php_pqdt_from_string(zv, NULL, val, len, "Y-m-d H:i:s", NULL TSRMLS_CC);
+ break;
+
+ case PHP_PQ_OID_TIMESTAMP:
+ if (!(res->auto_convert & PHP_PQRES_CONV_DATETIME)) {
+ goto noconversion;
+ }
+ php_pqdt_from_string(zv, NULL, val, len, "Y-m-d H:i:s.u", NULL TSRMLS_CC);
+ break;
+
+ case PHP_PQ_OID_TIMESTAMPTZ:
+ if (!(res->auto_convert & PHP_PQRES_CONV_DATETIME)) {
+ goto noconversion;
+ }
+ php_pqdt_from_string(zv, NULL, val, len, "Y-m-d H:i:s.uO", NULL TSRMLS_CC);
+ break;
+
+#if PHP_PQ_HAVE_PHP_JSON_H && defined(PHP_PQ_OID_JSON)
+# ifdef PHP_PQ_OID_JSONB
+ case PHP_PQ_OID_JSONB:
+# endif
+ case PHP_PQ_OID_JSON:
+ if (!(res->auto_convert & PHP_PQRES_CONV_JSON)) {
+ goto noconversion;
+ }
+ php_json_decode_ex(zv, val, len, PHP_PQRES_JSON_OPTIONS(res), 512 /* PHP_JSON_DEFAULT_DEPTH */ TSRMLS_CC);
+ break;
+#endif
+
+ default:
+ if (!(res->auto_convert & PHP_PQRES_CONV_ARRAY)) {
+ goto noconversion;
+ }
+ if (PHP_PQ_TYPE_IS_ARRAY(typ) && (Z_ARRVAL_P(zv) = php_pq_parse_array(res, val, len, PHP_PQ_TYPE_OF_ARRAY(typ) TSRMLS_CC))) {
+ Z_TYPE_P(zv) = IS_ARRAY;
+ } else {
+ noconversion:
+ ZVAL_STRINGL(zv, val, len, 1);
+ }
+ break;
+ }
+
+ return zv;
+}
+
+static inline zval *php_pqres_get_col(php_pqres_t *r, unsigned row, unsigned col TSRMLS_DC)
+{
+ zval *zv;
+
+ if (PQgetisnull(r->res, row, col)) {
+ MAKE_STD_ZVAL(zv);
+ ZVAL_NULL(zv);
+ } else {
+ zv = php_pqres_typed_zval(r, PQgetvalue(r->res, row, col), PQgetlength(r->res, row, col), PQftype(r->res, col) TSRMLS_CC);
+ }
+
+ return zv;
+}
+
+static inline void php_pqres_add_col_to_zval(php_pqres_t *r, unsigned row, unsigned col, php_pqres_fetch_t fetch_type, zval *data TSRMLS_DC)
+{
+ if (PQgetisnull(r->res, row, col)) {
+ switch (fetch_type) {
+ case PHP_PQRES_FETCH_OBJECT:
+ add_property_null(data, PQfname(r->res, col));
+ break;
+
+ case PHP_PQRES_FETCH_ASSOC:
+ add_assoc_null(data, PQfname(r->res, col));
+ break;
+
+ case PHP_PQRES_FETCH_ARRAY:
+ add_index_null(data, col);
+ break;
+ }
+ } else {
+ zval *zv;
+
+ zv = php_pqres_typed_zval(r, PQgetvalue(r->res, row, col), PQgetlength(r->res, row, col), PQftype(r->res, col) TSRMLS_CC);
+
+ switch (fetch_type) {
+ case PHP_PQRES_FETCH_OBJECT:
+ add_property_zval(data, PQfname(r->res, col), zv);
+ zval_ptr_dtor(&zv);
+ break;
+
+ case PHP_PQRES_FETCH_ASSOC:
+ add_assoc_zval(data, PQfname(r->res, col), zv);
+ break;
+
+ case PHP_PQRES_FETCH_ARRAY:
+ add_index_zval(data, col, zv);
+ break;
+ }
+ }
+}
+