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.
Tag: what is
How REGEXP_REPLACE() Works in PostgreSQL
In PostgreSQL, we can use the regexp_replace() function to replace a substring within a given string, based on a given POSIX regular expression. We can specify that all matches are replaced or just the first match.
We pass the string as the first argument, the pattern as the second, and the replacement text as the third argument. We also have the option of specifying the start position as the fourth argument, and we can specify a flag to determine how the function behaves.
Continue readingQuick Intro to the event_scheduler System Variable in MySQL
In MySQL, the event_scheduler system variable is used to start and stop the Event Scheduler, as well as enable or disable it.
At runtime we can set the value to ON or OFF, and we can check the current value of the variable. We can also disable the Event Scheduler at server startup, but we can’t do this at runtime. However, we can still check the event_scheduler variable to see whether it’s enabled or disabled.
How the CHR() Function Works in PostgreSQL
In PostgreSQL, we can use the chr() function to return a character based on its code.
The code is provided as an integer argument, and the function returns the character that the code represents. When using UTF8 encoding the argument is treated as a Unicode code point, otherwise it must designate an ASCII character.
Continue readingUnderstanding PostgreSQL’s UNISTR() Function
PostgreSQL has a unistr() function that evaluates escaped Unicode characters in its argument and returns the result as text.
A Quick Look at the GCD() Function in PostgreSQL
In PostgreSQL, gcd() is a mathematical function that returns the greatest common divisor. We pass two numbers and the function returns the largest positive number that divides both inputs with no remainder.
An Overview of PostgreSQL’s LCM() Function
In PostgreSQL, lcm() is a mathematical function that returns the least common multiple. We pass two numbers and the function returns the smallest strictly positive number that is an integral multiple of both inputs.
Understanding Composite Types in PostgreSQL
In PostgreSQL, a composite type is a kind of data type that consists of multiple data types. It consists of a list of field names and their respective data types.
We can use composite types to fit multiple fields into one column.
We can create our own custom composite types, and they can be used in many of the same scenarios that simple data types can be used.
Continue readingUnderstanding PostgreSQL’s TRANSLATE() Function
PostgreSQL has a translate() function which replaces certain characters in a string with certain other characters.
We specify the characters in the string that we want to replace, as well as the characters that we want to replace them with. The function then performs the translation and returns the string with the replaced characters.
Continue readingA Quick Look at TO_ASCII() in PostgreSQL
In PostgreSQL, we can use the to_ascii() function to convert a string to ASCII from another encoding. This usually involves dropping any accents (diacritic signs) from the original string.
We pass the string as an argument to the function. We also have the option of specifying the encoding (either its name or its number).
Continue reading