Correct Answer: to_tsvector () normalizes the string while ::tsvector does not
Explanation:
Note: This Question is unanswered, help us to find answer for this one
PostgreSQL Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More PostgreSQL MCQ Questions
Which will retrieve the number of values stored in an array column?
What interfaces are available in the base distribution of PostgreSQL?
Given a table special_products that inherits from a table store_products, which of the following statements will modify store_products only without affecting its child table?
Which of the following queries will create a table with two fields, 'id' and 'name' with 'id' as an auto incrementing primary key?
In the following list, which operators do a case insensitive string matching?
Which of the following statements will produce an error?
What is the command used to import a backup made with pg_dumpall > file.dmp?
For proper results, which of the following should contain a tsvector?
When using LIKE to compare strings, what is the wildcard operator (operator which matches zero or more characters)?
Which PostgreSQL version added the enum datatype?