PATSTAT 2017 Autumn - text search operators and non full-text Index table error
Posted: Wed Feb 14, 2018 5:38 pm
I am working with PATSTAT 2017 autumn. I have couple of queries mentioned below:
(1) I am new to PATSTAT database. I need to run a few queries which requires search in application title and application abstract fields. The only text search operator I know is "%". Can anybody please tell me or provides me with any link to show what other text search operators PATSTAT supports.
(2) I tried using CONTAINS (with NEAR) operator in application title column but it is showing error "Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tls202_appln_title' because it is not full-text indexed". Can anybody please tell me how to convert this table to full-text indexed table or how to use NEAR operator between two or more keywords.
Thanks a lot in advance!
(1) I am new to PATSTAT database. I need to run a few queries which requires search in application title and application abstract fields. The only text search operator I know is "%". Can anybody please tell me or provides me with any link to show what other text search operators PATSTAT supports.
(2) I tried using CONTAINS (with NEAR) operator in application title column but it is showing error "Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tls202_appln_title' because it is not full-text indexed". Can anybody please tell me how to convert this table to full-text indexed table or how to use NEAR operator between two or more keywords.
Thanks a lot in advance!