How do you perform case-insensitive searches using regular expressions

1.	How do you perform case-insensitive searches using regular expressions in PostgreSQL?
Answer» To PERFORM CASE INSENSITIVE matches using a regular expression, we can use POSIX (~) expression from pattern matching OPERATORS. For EXAMPLE: 'interviewbit' ~ '.INTervIewBit.'

Discussion