8000 `like`/`ilike` operator only works with varchar/text type columns in postgres · Issue #16722 · frappe/frappe · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
like/ilike operator only works with varchar/text type columns in postgres #16722
Open
@phot0n

Description

@phot0n

like operator works fine with different datatypes in mariadb but in postgres it's restrictive (probably since it doesn't do implicit type casts - and it also makes sense :P)

in mariadb:
Screenshot 2022-04-22 at 5 19 57 PM

Screenshot 2022-04-22 at 5 20 09 PM

in postgres:
Screenshot 2022-04-22 at 5 19 00 PM

Screenshot 2022-04-22 at 5 21 10 PM

Metadata

Metadata

Assignees

No one assigned

    Labels

    postgrespostgres db related issue/PRs

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      0