PostgreSQL – LPAD Function

ByAdmin

The LPAD function is used to pad a string on the left side with a specified character or a repeated sequence of characters, until the resulting string reaches a specified length. This function is often used to align strings to a specific width.

The syntax of the LPAD function is as follows:

LPAD(string, length, fill_character)

where string is the input string that you want to pad,

and length is the desired length of the resulting padded string,

and fill_character is the character or sequence of characters used to pad the input string.

Here’s an example of how you might use the LPAD function in a SQL query:

SELECT LPAD('Hello', 10, '*') AS padded_string;

In this example, the result would be the string '*****Hello', as the LPAD function added 5 asterisks (*) to the left side of the input string 'Hello' to make it a total of 10 characters long.

You can also pad with spaces or other characters:

SELECT LPAD('123', 5, '0') AS padded_number;

In this case, the result would be the string '00123', as the LPAD function added two 0 characters to the left side of the input string '123'.

The LPAD function can be useful when you need to format and align data in your SQL queries or reports.

Similar Posts

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…

PostgreSQL – REVERSE Function

ByAdmin

The REVERSE function is used to reverse the order of characters in a given string. It takes a string as an argument and returns a new string with the characters reversed. Here’s the basic syntax of the REVERSE function: REVERSE(string) Here’s an example of using the REVERSE function: SELECT REVERSE(‘Hello, World!’); — Returns ‘!dlroW ,olleH’…