title: How to find the first and last occurrences of a specific character inside a string in PostgreSQL
body: <p>I want to find the first and the last occurrences of a specific character inside a string. As an example, consider a string named "2010-####-3434", and suppose the character to be searched for is "#". The first occurrence of hash inside the string is at 6-th position, and the last occurrence is at 9-th position. </p>