SQL practice: Full-Text Search: Beyond LIKE

Convert the text 'South Facade Works' into a tsvector using the english configuration, in a column named doc.

List the customer_name of every customer whose name matches the search term 'facade', using to_tsvector and to_tsquery. Order by customer_name.

Find customers matching both 'panel' and 'house', using plainto_tsquery so the words can be passed in as a plain phrase. Show customer_name, ordered by customer_name.

Use websearch_to_tsquery to find customers matching the phrase "facade works", quoted so the words must be adjacent. Show customer_name, ordered by customer_name.

Rank customers against the query 'facade' and show customer_name with the score in a column named rank, best first, then by name.

Find every product whose name matches 'sheet' but not 'silver', using to_tsquery with the & and ! operators. Show product_name, ordered by product_name.

You add a GIN index on to_tsvector(customer_name) but your queries use to_tsvector('english', customer_name). Why is the index never used?