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.