Hi All,
please find herewith the following query
1. select * from partdetails where scode=118 and
(to_tsvector('english'::regconfig, part_number::text)) @@ to_tsquery('104')
it is showing only 1 record as output, it is expected to give 17 records as output.
2. select * from partdetails where scode=118 and
(to_tsvector('english'::regconfig, part_number::text)) @@ to_tsquery('104/')
it is showing only 1 record as output, it is expected to give 17 records as output.
3. select * from partdetails where scode=118 and
(to_tsvector('english'::regconfig, part_number::text)) @@ to_tsquery('104/1')
it is showing 17 records as output.
In our search case we are passing parameter value as 104 and expected to get 17 records.
Kindly some one guide here.