Postgres Pro
Downloads
Home   >   mailing lists

Thread: String match function required like utl_match in oracle

String match function required like utl_match in oracle

From
Jimit Amin
Date:

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

From
Charles Clavadetscher
Date:
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

From
Jimit Amin
Date:
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