position Function in PostgreSQL

In PostgreSQL, the POSITION function is used to find the position of a substring within a string. It returns the position of the first occurrence of the substring within the string, starting from 1. If the substring is not found, it returns 0.

Here's the syntax of the POSITION function in PostgreSQL:

POSITION(substring IN string)

- substring: The substring to search for within the string.

- string: The string in which to search for the substring.

Example:

SELECT POSITION('world' IN 'hello world') AS position;

This will return 7, indicating that the substring 'world' starts at the 7th position within the string 'hello world'.