Test=# SELECT * FROM t_database WHERE real_name ILIKE 'postgr%' Īs you can see, we can find all incarnations of PostgreSQL in an easy way. LIKE and ILIKE are the classical means to do similarity search in PostgreSQL: LIKE queries: When we know at least something
The citext extension is available on all public clouds including Amazon AWS, Microsoft Azure and so on.
Postgresql vs sql server software#
Solving the case-sensitivity issue on the data type level is really nice and makes life a lot easier for all software making use of the database. Just the comparison function is a bit more relaxed. Test=# SELECT * FROM t_database WHERE real_name = 'postgresql' Īs you can see, the data in the table is elegantly preserved. The following example shows how it works: In addition to that developers have to keep these things in mind at all times which can lead to bugs.įortunately, there is a more simplistic solution available: The “citext” datatype (as provided by the “citext” extension) can handle case-insensitive comparisons. Of course one can work around this problem using “upper” and “lower” but in many cases this is simply less convenient than it should be. There is one common thing people need quite frequently: Case-insensitive search. Simple case-insensitive search in PostgreSQL ('MS SQL Server'), ('Microsoft SQL Server') Īll we have here is the name of some database along with a handful of different spellings and typos. Depending on what kind of search you need you can choose between various methods.īefore we get started it is necessary to compile some sample data: The question therefore is: How can one find data even if there are typos? In PostgreSQL there are various solutions to the problem. Is it Postgre, PostGreSQL, Postgres or PostgreSQL? We have all seen a couple of wrong ways to spell “PostgreSQL”.
0 kommentar(er)
