position Function in Greenplum

In Greenplum, which is based on PostgreSQL, the POSITION function behaves similarly to its PostgreSQL counterpart. It is used to find the position of a substring within a string. The function 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 Greenplum:

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 query will return 7, indicating that the substring 'world' starts at the 7th position within the string 'hello world'.