search id column in table
postgress sql:
SQLSTATE[42883]: Undefined function: 7 ERROR: function lower(bigint) does not exist LINE 1: ...e from "blg_categories" where "type_id" = $1 and (lower(id):... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
SELECT
count(*) AS aggregate
FROM
"blg_categories"
WHERE
"type_id" = -9009
AND (
lower(id):: text LIKE % 1 %
OR lower(title):: text LIKE % 1 %
OR lower(slug):: text LIKE % 1 %
)
SQLSTATE[42883]: Undefined function: 7 ERROR: function lower(bigint) does not exist LINE 1: ...e from "blg_categories" where "type_id" = $1 and (lower(id):... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
SELECT
count(*) AS aggregate
FROM
"blg_categories"
WHERE
"type_id" = -9009
AND (
lower(id):: text LIKE % 1 %
OR lower(title):: text LIKE % 1 %
OR lower(slug):: text LIKE % 1 %
)
Solution
That's a Postgres specific issue, being triggered by a workaround for another Postgres specific issue (case insensitive searching).
Try turning that off like this:
Try turning that off like this:
