From f844fc499e134c460b174df07bdb89de6e60987e Mon Sep 17 00:00:00 2001 From: =?utf8?q?Mat=C4=9Bj=20Hump=C3=A1l?= Date: Wed, 28 Feb 2018 16:17:12 +0100 Subject: [PATCH] Do not cast date/timestamp exact searches in PostgreSQL to text --- adminer/drivers/pgsql.inc.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/adminer/drivers/pgsql.inc.php b/adminer/drivers/pgsql.inc.php index 9b4ce038..63846844 100644 --- a/adminer/drivers/pgsql.inc.php +++ b/adminer/drivers/pgsql.inc.php @@ -194,7 +194,10 @@ if (isset($_GET["pgsql"])) { } function convertSearch($idf, $val, $field) { - return (preg_match('~char|text' . (is_numeric($val["val"]) && !preg_match('~LIKE~', $val["op"]) ? '|' . number_type() : '') . '~', $field["type"]) + return (preg_match('~char|text' + . (is_numeric($val["val"]) && !preg_match('~LIKE~', $val["op"]) ? '|' . number_type() : '') + . (!preg_match('~LIKE~', $val["op"]) ? '|date|timestamp' : '') + . '~', $field["type"]) ? $idf : "CAST($idf AS text)" ); -- 2.39.5