Re: levenshtein_less_equal does not work

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: levenshtein_less_equal does not work
Дата
Msg-id 52E2D85C.2020108@joeconway.com
обсуждение исходный текст
Ответ на Re: levenshtein_less_equal does not work  (alexandros_e <alexandros.ef@gmail.com>)
Ответы Re: levenshtein_less_equal does not work
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/24/2014 01:07 PM, alexandros_e wrote:
> SELECT levenshtein_less_equal('extensive', 'exhaustive',2);


Did you CREATE the extension?

8<-----------------------------

psql (9.3.2)
Type "help" for help.

iftest=# SELECT levenshtein_less_equal('extensive', 'exhaustive',2);
ERROR:  function levenshtein_less_equal(unknown, unknown, integer)
does not exist
LINE 1: SELECT levenshtein_less_equal('extensive', 'exhaustive',2);
               ^
HINT:  No function matches the given name and argument types. You
might need to add explicit type casts.

iftest=# create extension fuzzystrmatch;
CREATE EXTENSION

iftest=# SELECT levenshtein_less_equal('extensive', 'exhaustive',2);
 levenshtein_less_equal
- ------------------------
                      3
(1 row)

8<-----------------------------

psql (9.1.11)
Type "help" for help.

test=# create extension fuzzystrmatch;
CREATE EXTENSION
test=# SELECT levenshtein_less_equal('extensive', 'exhaustive',2);
 levenshtein_less_equal
- ------------------------
                      3
(1 row)

8<-----------------------------

We need more specific info about how you obtained and installed the
extension.

Joe

- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIcBAEBAgAGBQJS4thcAAoJEDfy90M199hlXisP/1wnp9j4311QENBWAM23xosl
JO68J4dt6LaexrG2cXYKdVZ1steTg4LG2yEPnW1ED132pqa/yt/d+xmA7TAUNHnS
es3PAw45XTFbVp5/tUhBhKnx3sEkLwE5ONDH1AjHDq/gUJMPf83xYhxYuP8rcXuY
0/cGof4pINMkfA94tKnr34x+N0xoY3jfTXPzE6x8Zci+78Kpx/SiCRlylAURexza
sKHmcDUqzvnaH+LzTsS1F06tybjJh/pHVNlA/TMhyV5AEfLmVDR7LpA4yVROX7Nh
qw3dBciCy7Q0GVqBNVK8UZzynlGhd3m7ldUN0tDZxovP1KEo5L+5D/oXU2Piejtb
Y7bJqS9nqx8xLNkQZ+Zqsj7nXhzLF9SdCumF/6q0gCCkP97+13RESMGIr/4Un4KJ
Wb4L28iilRZifbvJ9LV2grLUxoZCZeJEhQqfcjiwrBNGJMRPFZ0sveEIIeHa2H8m
/3UfkSyklMGkYupemLFlXTz4qD8m6giizUpbOVbEjBicIvpMwTP6ebuZjzpwI9ui
DbYRcTvWeLdVUKTq8ZCUmKUuaiqgRMJWGMYA7UVKHKf3aJ+v7+F9ddXD8YLTVO6Z
cVhigwR22rGmP+si4tWMu9JOVYjhuUsrlUeGHfZALmTOUbaKRQScnR+jwXSf+a9w
kqNSFvwOHVxD6fIgmjgK
=+GSh
-----END PGP SIGNATURE-----


В списке pgsql-general по дате отправления:

Предыдущее
От: alexandros_e
Дата:
Сообщение: Re: levenshtein_less_equal does not work
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: levenshtein_less_equal does not work