PostgreSQL RIGHT

The PostgreSQL RIGHT() function returns the last n characters in a string.

Syntax

The following shows the syntax of the PostgreSQL RIGHT() function:

Arguments

The PostgreSQL RIGHT() function requires two arguments:

1) string

is a string from which a number of the rightmost characters returned.

2) n

is a positive integer which specifies the number of the rightmost characters in the string should be returned.

If n is negative, the RIGHT() function returns all characters in the string but first |n| (absolute) characters.

Return value

The PostgreSQL RIGHT() function returns the last n characters in a string.

Examples

Let’s look at some examples of using the PostgreSQL RIGHT() function.

The following statement gets the last character in the string 'XYZ':

Here is the result:

To get the last two characters, you pass the value 2 as the second argument as follows:

And the result is:

The following statement illustrates how to use a negative integer as the second argument:

In this example, the RIGHT() function returns all character except for the first character.

See the following customer table in the sample database:

The following statement uses the RIGHT() function in WHERE clause to get all customers whose last names ended with 'son':

The following picture illustrates the result:

Remarks

If you want to return the n first characters, please check the LEFT() function for more detailed information.

In this tutorial, you’ve learned how to use the PostgreSQL RIGHT() function to get the n rightmost characters in a string.