Skip to content

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

Description

@transtone

使用如下查询时出错:

{
	"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 文档中查不到,可以补上这个功能的文档。

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions