The Enum (enumeration) data type in SQL is a specialised string object that allows us to define a list of predefined values for a column. This data type can be particularly useful when we want to restrict the possible values that can be stored in a specific column to a fixed set of options.
Tag: what is
A Quick Look at the ASCII() Function in PostgreSQL
In PostgreSQL, we can use the ascii() function to get the numeric code of the first character of the argument.
When using UTF8, the function returns the Unicode code point of the character. Other multibyte encodings require an ASCII character.
Continue readingSQL Truncate Explained
In SQL databases, the TRUNCATE statement can be used to quickly remove all data from a table. Unlike the DELETE statement, TRUNCATE is typically faster and uses fewer system resources, especially for large tables.
In this article, we’ll explore the TRUNCATE statement, its usage, and provide some examples.
Understanding PostgreSQL’s SPLIT_PART() Function
The PostgreSQL split_part() function splits a string based on a specified delimiter and then returns the specified part from the split string.
The function accepts three arguments; the string, the delimiter, and the part that we want to return.
Continue readingA Quick Look at PostgreSQL’s PG_CLIENT_ENCODING() Function
In PostgreSQL, we can use the pg_client_encoding() function to get the current client encoding name.
Understanding the RIGHT() Function in PostgreSQL
In PostgreSQL the right() function returns the specified number of rightmost characters in a given string.
We have the option of specifying the number of characters to return from the right or the number of characters to omit from the left. We do this by specifying a positive integer (to return n number of rightmost characters) or a negative integer (to return everything except n leftmost characters).
Continue readingA Quick Look at the LEFT() Function in PostgreSQL
In PostgreSQL we can use the left() function to get the specified number of leftmost characters in a given string.
We have the option of specifying the number of characters to return from the left or the number of characters to omit from the right. We do this by specifying a positive integer (to return n number of leftmost characters) or a negative integer (to return everything except n rightmost characters).
Continue readingSQL Server WHILE Loop (with Examples)
The WHILE loop in SQL Server is a control-flow statement that allows us to repeatedly execute a block of code as long as a specified condition is true. It’s useful for iterative tasks and processing data in batches.
A Quick Overview of the ERFC() Function in PostgreSQL
In PostgreSQL, erfc() is a mathematical function that provides the mathematical complementary error function, without loss of precision for large inputs. It returns 1 - erf(x).
The erfc() function was introduced in PostgreSQL 16, which was released on September 14th 2023.
A Quick Intro to PostgreSQL’s ERF() Function
In PostgreSQL, erf() is a mathematical function that provides the standard mathematical error function.
The erf() function was introduced in PostgreSQL 16, which was released on September 14th 2023.