On Fri, Jul 12, 2013 at 11:48 AM, itishree sukla
<itishree.su...@gmail.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/
