![]() ![]() The value can be a character or a number. There are the following topics that we will cover in this tutorial. PostgreSQL UPPER() function using Column : Sample Table: employees. The _ wildcard matches exactly one value. In this PostgreSQL tutorial, we will learn about Postgresql ilike case insensitive which is similar to the behaviour of the LIKE operator, but ILIKE is unique because it is used for case-insensitive pattern matching.The operator is equivalent to LIKE, and corresponds to ILIKE. ![]() This is not in the SQL standard but is a PostgreSQL extension. The key word ILIKE can be used instead of LIKE to make the match case-insensitive according to the active locale.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |