String match function required like utl_match in oracle

Started by Jimit Aminalmost 11 years ago3 messagesgeneral
Jump to latest
#1Jimit Amin
jimitamin9@gmail.com

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

#2Charles Clavadetscher
clavadetscher@swisspug.org
In reply to: Jimit Amin (#1)
Re: String match function required like utl_match in oracle

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

#3Jimit Amin
jimitamin9@gmail.com
In reply to: Charles Clavadetscher (#2)
Re: String match function required like utl_match in oracle

Thanks, It is somewhat useful.

Jimit Amin

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

Show quoted text

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