Re: [SQL] Compare strings which resembles each other

2003-11-21 Thread Oleg Bartunov
On Fri, 21 Nov 2003, Ian Barwick wrote: > On Friday 21 November 2003 15:32, Oleg Bartunov wrote: > > On Fri, 21 Nov 2003, Christoph Haller wrote: > > > > $PGSQLD/contrib/tsearch/README.tsearch > > > is your friend. > > > > I think tsearch(2) isn't what Gulshan need. He needs fuzzy search, > > ther

Re: [SQL] Compare strings which resembles each other

2003-11-21 Thread Ian Barwick
On Friday 21 November 2003 15:32, Oleg Bartunov wrote: > On Fri, 21 Nov 2003, Christoph Haller wrote: > > $PGSQLD/contrib/tsearch/README.tsearch > > is your friend. > > I think tsearch(2) isn't what Gulshan need. He needs fuzzy search, > there are several modules in contrib directory (metaphone, f

Re: [SQL] Compare strings which resembles each other

2003-11-21 Thread Oleg Bartunov
On Fri, 21 Nov 2003, Christoph Haller wrote: > > > > Hy, I have a table containing some rows. Each row contains a field name > > which is of type String. > > > > For example: > > in row1 string1 is "Adieu Poulet", > > in row2 string2 is "Adieu a Poulet", > > in row3 string3 is "Adiue Poulet", > >

Re: [SQL] Compare strings which resembles each other

2003-11-21 Thread Christoph Haller
> > Hy, I have a table containing some rows. Each row contains a field name > which is of type String. > > For example: > in row1 string1 is "Adieu Poulet", > in row2 string2 is "Adieu a Poulet", > in row3 string3 is "Adiue Poulet", > in row4 string4 is "Adieu Pouleet", etc.. > (That is each stri

[SQL] Compare strings which resembles each other

2003-11-19 Thread Gulshan Babajee
Hy, I have a table containing some rows. Each row contains a field name which is of type String. For example: in row1 string1 is "Adieu Poulet", in row2 string2 is "Adieu a Poulet", in row3 string3 is "Adiue Poulet", in row4 string4 is "Adieu Pouleet", etc.. (That is each string resembles each oth