Search code examples
postgresqlcharindex

What is the CHARINDEX (SQL SERVER) equivalent in POSTGRESQL?

I am trying CHARINDEX in Postgresql. But it says:

function CHARINDEX() does not exist

If no such inbuilt function exists in postgresql, then is there any function that serves as an alternative to charindex?
If yes, What is the CHARINDEX (SQL SERVER) equivalent in POSTGRESQL ?

Solution

  • The equivalent function in postgresql is:

    strpos(string, substring)

    Or:

    position(substring in string)

    They are equivalent, just with different order in parameters.
    If you also need parameter start_location, you will need to pass a substring to strpos.

    You can find them in: https://www.postgresql.org/docs/current/functions-string.html