![]() This is simple enough and, hopefully, something you're fully familiar with.īut PostgreSQL is an RDBMS capable of much more than simply storing and retrieving data. You have wildcards such as % (as in LIKE 'a%' to search for columns that start with "a"), and _ (as in LIKE '_r%' to find any values that have an "r" in the second position) and in PostgreSQL you can also use ILIKE to ignore cases. That will return the rows where column_name matches the pattern. You're probably familiar with pattern search, which has been part of the standard SQL since the beginning, and available to every single SQL-powered database: SELECT column_name FROM table_name WHERE column_name LIKE 'pattern' In this installment of Mastering PostgreSQL Tools we'll see how PostgreSQL's full-text search features, and how they're expanded in version 9.6 for phrase search and word proximity. Yes, PostgreSQL 9.6 has been finally rolled out on Compose, and with it, a whole set of features and improvements. In his latest Compose Write Stuff article on Mastering PostgreSQL Tools, Lucero Del Alba writes about mastering full-text and phrase search in PostgreSQL 9.6. Mastering PostgreSQL Tools: Full-Text Search and Phrase Search postgresql full-text search phrase search Free 30 Day Trial
0 Comments
Leave a Reply. |