Обсуждение: String match function required like utl_match in oracle

Поиск
Список
Период
Сортировка

String match function required like utl_match in oracle

От
Jimit Amin
Дата:

Hello,

I want to compare 2 string and want result like how much percentage or how much part string is compared. Can I know any option like utl_match in oracle

Jimit Amin

Re: String match function required like utl_match in oracle

От
Charles Clavadetscher
Дата:
Or maybe even better:

http://www.postgresql.org/docs/9.4/static/fuzzystrmatch.html

Search for Levenshtein.

Bye
Charles

On 7/4/2015 11:50, Jimit Amin wrote:
> Hello,
>
> I want to compare 2 string and want result like how much percentage or
> how much part string is compared. Can I know any option like utl_match
> in oracle
>
> Jimit Amin
>


Re: String match function required like utl_match in oracle

От
Jimit Amin
Дата:
Thanks, It is somewhat useful.


Jimit Amin

On Sat, Jul 4, 2015 at 3:51 PM, Charles Clavadetscher <clavadetscher@swisspug.org> wrote:
Or maybe even better:

http://www.postgresql.org/docs/9.4/static/fuzzystrmatch.html

Search for Levenshtein.

Bye
Charles

On 7/4/2015 11:50, Jimit Amin wrote:
Hello,

I want to compare 2 string and want result like how much percentage or
how much part string is compared. Can I know any option like utl_match
in oracle

Jimit Amin



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general