Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

searches?

April 26, 2017Searches

0

Posted

searches?

1 Answer

0

Posted

614 615 The ~ operator does regular expression matching, and ~* does 616 case-insensitive regular expression matching. The case-insensitive 617 variant of LIKE is called ILIKE. 618 619 Case-insensitive equality comparisons are normally expressed as: 620 SELECT * 621 FROM tab 622 WHERE lower(col) = ‘abc’; 623 624 This will not use an standard index. However, if you create an 625 expression index, it will be used: 626 CREATE INDEX tabindex ON tab (lower(col)); 627 628 If the above index is created as UNIQUE, though the column can store 629 upper and lowercase characters, it can not have identical values that 630 differ only in case. To force a particular case to be stored in the 631 column, use a CHECK constraint or a trigger.