PostgreSQL – TRIM Function

ByAdmin

The TRIM() function is used to remove specified characters or whitespace from the beginning and/or end of a string. It’s often used to clean up or manipulate strings by removing unwanted leading or trailing characters.

The syntax of the TRIM() function is as follows:

TRIM([ [ BOTH | LEADING | TRAILING ] trim_character FROM ] string )

  • BOTH, LEADING, or TRAILING: These are optional keywords that specify the direction from which to trim characters. If omitted, the default is BOTH. BOTH trims characters from both the beginning and end of the string, LEADING trims characters only from the beginning, and TRAILING trims characters only from the end.
  • trim_character: An optional parameter that specifies the character or characters to be trimmed from the string. If omitted, the function trims whitespace characters (spaces, tabs, etc.).
  • string: The input string from which characters will be trimmed.

Here are some examples of how to use the TRIM() function in PostgreSQL:

  1. Removing leading and trailing spaces from a string:

SELECT TRIM(' Hello, World! ') AS trimmed_string;

This would result in the output: "Hello, World!"

  1. Trimming specific characters from both ends of a string:

SELECT TRIM('-' FROM '--12345---') AS trimmed_string;

This would result in the output: "12345"

  1. Trimming specific characters only from the beginning of a string:

SELECT TRIM(LEADING '0' FROM '00012345') AS trimmed_string;

This would result in the output: "12345"

  1. Trimming specific characters only from the end of a string:

SELECT TRIM(TRAILING '.' FROM '12.34.56.') AS trimmed_string;

This would result in the output: "12.34.56"

Similar Posts

PostgreSQL – REGEX_REPLACE Function

ByAdmin

The REGEXP_REPLACE function is used to replace substrings within a string based on a regular expression pattern. It allows you to perform advanced pattern-based replacements on text data. The syntax of the REGEXP_REPLACE function is as follows: REGEXP_REPLACE(string, pattern, replacement, flags) where string is the input string in which you want to perform replacements. and…

PostgreSQL – RPAD Function

ByAdmin

The rpad function in PostgreSQL database is used to right-pad a string with a specified character or a set of characters until the resulting string reaches a specified length. This function is often used to format strings to a fixed width. Here’s the syntax for the rpad function: rpad(input_string, length, pad_string) The rpad function takes…