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 – 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…

PostgreSQL – FORMAT Function

ByAdmin

The FORMAT function is used to format a string using placeholders that are replaced with corresponding values. It’s a powerful function that allows you to create formatted strings with specific patterns and insert values into those patterns. The syntax of the FORMAT function is as follows: FORMAT(format_string, value1, value2, …) where format_string is the string…

PostgreSQL – MD5 Function

ByAdmin

The MD5 function is used to calculate the MD5 hash value of a given input string. MD5 (Message Digest Algorithm 5) is a widely used cryptographic hash function that produces a fixed-size 128-bit (16-byte) hash value, typically represented as a 32-character hexadecimal number. The syntax of the MD5 function is as follows: MD5(string) where string…