Question : I had to write a simple query where I go looking for people’s name that start with a […]
Tag: pattern-matching
PostgreSQL LIKE query on ARRAY field
Question : Is there any way to have a Postgres LIKE query on a ARRAY field? Currently I want something […]
Trying to check if a string contains a number exclusively
Question : I have been trying to write a function to check if a string contains a number without that […]
PostgreSQL 8.4 no levenshtein fuzzymatching?
Question : I’m using debian squeeze package, it says function does not exist? Answer : You have to install the […]
PostgreSQL full text search on many columns
Question : I need an advice with searching of record based on specified string. Search strings can contain values from […]
Postgres trigram match acting strange for specific characters
Question : I’m using pg_trgm to run a query, but I’m getting a lot of 1 matches when searching with […]
MATCH AGAINST one character words returns empty rows with ft_min_word_len = 1
Question : I’ve set ft_min_word_len = 1 to my.cnf file, also SHOW VARIABLES LIKE ‘ft_min_word%’ displays ft_min_word_len as 1. Then […]
Full text search in PostgreSQL with search term including unrelated hyphen and ending
Question : I’ve a problem in my DB (PGSQL 9.6) that I’ve not been able to resolve and I don’t […]
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 […]