Question : I’ve a problem in my DB (PGSQL 9.6) that I’ve not been able to resolve and I don’t […]
Tag: pattern-matching
Replace a sequential set of numbers with special character
Question : I have a varchar(200) column that contains entries such as, ABC123124_A12312 ABC123_A1212 ABC123124_B12312 AC123124_AD12312 A12312_123 etc.. I want […]
Oracle equivalent to MS-Access character range/set
Question : In MS-Access, I can use character ranges/sets in the where clause: SELECT table_name FROM all_tab_columns WHERE table_name NOT […]
Why would you index text_pattern_ops on a text column?
Question : Today Seven Databases in Seven Weeks introduced me to per-operator indexes. You can index strings for pattern matching […]
How to filter a character followed by numbers string pattern in PostgreSQL?
Question : Back in SQL Server, I use the command below to get the matching string pattern of #1234 from […]
SQL Server: Replace with wildcards?
Question : Does Microsoft SQL Server natively support some sort of replace function using wild cards? I gather that Regular […]
How to query efficiently from Postgres to select special words?
Question : Let’s say that I have a table called words with very many records. Columns are id and name. […]
Set var=”NEW.this_word_column” in a trigger function if “word” is present in a column name
Question : Context I’m using PostgreSQL 10.12. I want to be able to fire a trigger function on some specific […]
Find rows in which the column doesn’t contain a “space”
Question : I’m using Postgres 9.5. I want to search for rows in which my name column does not contain […]
Efficient way to see what pattern matches a single word
Question : I’m creating a function to find out what search pattern would best fit a single string. The string […]