Re: levenshtein_less_equal does not work

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/24/2014 01:38 PM, alexandros_e wrote:
> =# \dx List of installed extensions Name   | Version |   Schema   |
> Description
> ---------+---------+------------+------------------------------
> plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language (1
> row)


According to this you have not CREATED fuzzystrmatch extension.

> -# \df  levenshtein* List of functions Schema |    Name     |
> Result data type | Argument data types |  Type
> --------+-------------+------------------+---------------------+--------
>
>
public | levenshtein | integer          | text, text          | normal
> (1 row)

> The server is in localhost. The binaries are from enterpriseDB. I
> also downloaded src code for Postgres 9.1.11. Recompiled
> fuzzystrmatch, which includes levenstein less_equal. Replaced .so
> file in Postgres installation dir. Change in levenshtein limit of
> character successful.
>
> It is not a compilation error, because I do not get  levenstein
> less_equal in the Postgres 9.2 server which is exactly as
> downloaded from EnterpriseDB.

Simply replacing an .so file is not going to make any new functions
available from SQL. Are you sure the "CREATE EXTENSION fuzzystrmatch"
you ran was successful? (it sure looks like it was not from the above)

The output of those commands should look like:

test=# \df  levenshtein*
                                              List of functions
 Schema |          Name          | Result data type |
Argument data types               |  Type
-
--------+------------------------+------------------+------------------------------------------------+--------
 public | levenshtein            | integer          | text, text
                               | normal
 public | levenshtein            | integer          | text, text,
integer, integer, integer          | normal
 public | levenshtein_less_equal | integer          | text, text,
integer                            | normal
 public | levenshtein_less_equal | integer          | text, text,
integer, integer, integer, integer | normal
(4 rows)

test=# \dx
                                        List of installed extensions
     Name      | Version |   Schema   |
Description
-
---------------+---------+------------+---------------------------------------------------------------------
 fuzzystrmatch | 1.0     | public     | determine similarities and
distance between strings
 plpgsql       | 1.0     | pg_catalog | PL/pgSQL procedural language
(2 rows)

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/

iQIcBAEBAgAGBQJS4t8DAAoJEDfy90M199hlBWYP/1oT20qVXDrSjvfRhZNaZ1f+
iW7P3KuyRMiXpW3oXLzF/CI58ePewCFvZ0sIGMHWBGFpyS1bOeYKETpp2AXiActY
qwMDn3qkHaWiexEph158fdsqtIeaqNbJWOEWPkO6sm99Oib9hqWb18PUvKsDl9Xn
lmh+J5z8fL5MUBC30VlQW9TgpPSgl5CXbi2wi3k6bRIgF6DHnje2FOtxr+840u8d
PhIOcuHpPCdOzDZf9jFh9ZmYkeTTYxsi78EG0Vq+8YxpgqCzUgJPFGJDioc9+0Sy
gkvFO6CfmQnnbHZ4SPluQOc7TssREYvxIv9gcu0wlQxha0u2dVqyO12vrISgp4TA
WWNUl+ewF7UvQGkihU+bCHWnTSHKUuQhFt1HNZf6wnok8DItTnJioxLWUzWEERjD
42o6I+DctOI1frRMtXj9mkmxm+SmVfG1ozelQ2dwQyDiTXiuoKSedqLlcuY2POF8
tr1QMmOlhHz+3AzHAHwdvgSyQgCdyJNZz5deInxplG6jJ6JjlPyM91EXh9N8K+WR
wBp1XfIRb2DTHf1gbbl/iNX+GHZ7H5cUXhnre2y8TP1a19+DTOcvf3zvDAo51mCT
bD3Hs0CB5SdbYsQKfxn72eFC5o+wFYLZS0XHws0a1qJOEN0Tz1o57ozAJN7JIeW0
EJ4/zXgo2/41VxyVTJSk
=edCG
-----END PGP SIGNATURE-----