From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | gagan(dot)bhatia(at)xymob(dot)in |
Subject: | BUG #15461: Postgresql fuzzy match extension giving out error |
Date: | 2018-10-26 10:03:59 |
Message-ID: | 15461-d24bd3875e0f9264@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15461
Logged by: Gagandeep Singh Bhatia
Email address: gagan(dot)bhatia(at)xymob(dot)in
PostgreSQL version: 9.6.6
Operating system: x86_Linux 64 bits, compiled by gcc 4.8.2 20140120
Description:
I am using PostgreSQL DB hosted on AWS. I am trying to use fuzzy logic,
enabled its extension successfully. But running the fussy match Query gives
me an exception. Also verified, the extension is already enabled but still,
Query failed.
**Query used to enable extension** - CREATE EXTENSION pg_trgm;
**DB version details** - PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled
by gcc (GCC) 4.8.2 20140120 (Red Hat 4.8.2-16), 64-bit
**Query for fuzzy match** - SELECT first_name FROM contact WHERE first_name
% 'Eve' LIMIT 10;
**Error message -** SQL Error [42883]: ERROR: operator does not exist:
character varying % unknown
Hint: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
Position: 49
org.postgresql.util.PSQLException: ERROR: operator does not exist:
character varying % unknown
Hint: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
Position: 49
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-10-26 10:13:00 | Re: BUG #15461: Postgresql fuzzy match extension giving out error |
Previous Message | PG Bug reporting form | 2018-10-26 09:31:18 | BUG #15460: Error while creating index or constraint |