Founder of Big Machine and Tekpub. Author of The Imposter’s Handbook, creator of This Developer's Life, method speaker and Azure Developer[0] at @microsoft
Hey Jason great post! Quick thing on the full text example you have: if you use plianto_tsquery it will split the words for you and add the AND. If you use phraseto_tsquery it will apply a positional argument (<->) instead of the &, which is great if you're looking for a name or place. The new websearch_to_tsquery (in PG 11) is a great general purpose query builder as well.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Hey Jason great post! Quick thing on the full text example you have: if you use
plianto_tsquery
it will split the words for you and add the AND. If you usephraseto_tsquery
it will apply a positional argument (<->) instead of the &, which is great if you're looking for a name or place. The newwebsearch_to_tsquery
(in PG 11) is a great general purpose query builder as well.