Re: Full text search

On Fri, Jul 12, 2013 at 11:48 AM, itishree sukla
<itishree(dot)sukla(at)gmail(dot)com>wrote:

> Hello everyone,
>
> I am using full text search, however it is not helping me to get the
> partial value.
>
> For example in my document let Pizza Hut is there, if i am searching for
> Pizza Hut is it giving me the values for only Pizza or a spell mistake like
> pizz is not returning any thing. any work around for this, please suggest.
>
> Regards,
> Itishree
>

Hope you are looking like this.

create table foo(v text);
insert into foo values('Near to my house there\'s no any Pizza Hut
restuarant');
insert into foo values('I wont like pizza, but friends are crazy of it');

postgres=# select * from foo where v ~* 'pizz';
v
------------------------------------------------------
Near to my house there's no any Pizza Hut restuarant
I wont like pizza, but friends are crazy of it
(2 rows)

postgres=# select * from foo where v ~* 'pizza hut';
v
------------------------------------------------------
Near to my house there's no any Pizza Hut restuarant
(1 row)

postgres=# select * from foo where v ~* 'pizza';
v
------------------------------------------------------
Near to my house there's no any Pizza Hut restuarant
I wont like pizza, but friends are crazy of it
(2 rows)

or

with ILIKE

select * from foo where v ilike '%hut%';

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/