Tencent/APIJSON

不支持 postgresql 的 date 字段格式时的类型转换

transtone opened this issue · 1 comments

transtone commented

使用如下查询时出错：

{
	"data[]": {	
		"User": {        
			"birthday>=": "2022-08-28",
		},
        "format": true,
        "count": 3,
	},

}
org.postgresql.util.PSQLException: ERROR: operator does not exist: date >= character varying
  建议：No operator matches the given name and argument types. You might need to add explicit type casts.

==================

需要这样转换一下字段格式：

{
	"data[]": {	
		"User": {        
			"birthday>=": "2022-08-28",
                        "@cast": "birthday>=:DATE",
		},
        "format": true,
        "count": 3,
	},

}

Document.md 文档中查不到，可以补上这个功能的文档。