We can use PostgreSQL’s repeat() function to repeat a string multiple times. We pass the string to the function, along with an integer that specifies how many times we want it repeated, and it returns the string repeated that many times.
Tag: what is
Using REGEXP_SPLIT_TO_ARRAY() in PostgreSQL
In PostgreSQL, the regexp_split_to_array() function splits a string using a POSIX regular expression as the delimiter, and returns the result in a text array.
So we use a POSIX regular expression to specify the delimiter/s, and split the string based on that.
We pass the string as the first argument and the pattern as the second. We can also specify a flag to determine how the function behaves.
Continue readingHow REGEXP_SPLIT_TO_TABLE() Works in PostgreSQL
In PostgreSQL, the regexp_split_to_table() function splits a string using a POSIX regular expression as the delimiter, and returns the result in a table.
So we use a POSIX regular expression to specify the delimiter/s, and split the string based on that.
We pass the string as the first argument and the pattern as the second. We can also specify a flag to change the behaviour of the function.
Continue readingA Quick Look at PostgreSQL’s STARTS_WITH() Function
When using PostgreSQL, we can use the starts_with() function to check whether or not a string starts with a given substring.
We pass the string as the first argument, and the substring as the second.
It returns true if the string does start with the substring, otherwise it returns false.
Continue readingHow PostgreSQL’s SOME() Construct Works
PostgreSQL has the SOME() construct that we can use to perform searches against arrays. It returns a Boolean result, and so we can incorporate this into our searches to return just those rows that yield true or false.
SOME() is a synonym for ANY(), and so we can use either one to get the same result.
Understanding PostgreSQL’s LOG10() Function
In PostgreSQL, log10() is a mathematical function that returns the base 10 logarithm of its argument.
It was added in PostgreSQL 12 as a SQL-standard equivalent of the existing log() function.
There is a difference between the two functions though, because log() allows us to specify which base to use (although it defaults to base 10), whereas log10() uses base 10 only.
Using TRIM_SCALE() in PostgreSQL
In PostgreSQL, we can use the trim_scale() function to remove any trailing zeros from the end of the fractional part.
This doesn’t change the value, it merely reduces the number characters whenever there are unnecessary zeros on the end.
Continue readingHow MIN_SCALE() Works in PostgreSQL
In PostgreSQL, min_scale() is a mathematical function that returns the minimum scale needed to represent the supplied value precisely.
The “scale” is the number of fractional decimal digits. For example, a value of 1.9500 has a minimum scale of 2, whereas 1.957 has a minimum scale of 3.
We pass the value to the function as a numeric argument, and it returns the result as an integer.
A Quick Look at PostgreSQL’s REVERSE() Function
In PostgreSQL, we can use the reverse() function to return a specified string with its characters reversed. In other words, the string is returned with its characters in the reverse order to how we provided them.
Understanding PostgreSQL’s REGEXP_MATCHES() Function
In PostgreSQL, the regexp_matches() function returns substrings that match a given POSIX regular expression in a given string. We can specify that all matches are returned or just the first match. If all matches are returned, each is returned in a separate row.
We pass the string as the first argument and the pattern as the second argument. We can also provide a flag as an optional third argument, which determines how the function behaves.
Each returned row is a text array containing the whole matched substring or the substrings matching parenthesised subexpressions of the pattern.
Continue reading