PostgreSQL

A Brief Overview of SUBSTR() in PostgreSQL

by

In PostgreSQL, we can use the the substr() function to return a substring from a string, based on a starting point. We have the option of specifying how many characters to return.

We pass the string as the first argument and the start position as the second. If we want to specify how long the substring should be, we can pass a third argument that specifies how many characters to return.

The function returns the same result as the substring() function (which uses a slightly different syntax).

Read more

Fix “function array_sample(numeric, integer) does not exist” in PostgreSQL

by

If you’re getting an error that reads “function array_sample(numeric, integer) does not exist” when using the array_sample() function in PostgreSQL, it’s probably because your first argument is a numeric type instead of an array.

The first argument for this function must be an array.

To fix this error, be sure that your first argument to array_sample() is an array, not a numeric value.

Read more

Fix “function array_shuffle(integer) does not exist” in PostgreSQL

by

If you’re getting an error that reads “function array_shuffle(integer) does not exist” when using the array_shuffle() function in PostgreSQL, it’s probably because the argument you’re passing to the function is not an array.

More specifically, this error message implies that you’re passing an integer. The same error can occur when passing other non-array types (such as numeric), but the solution is the same.

The argument for this function must be an array.

To fix this error, replace the integer value with an array value when calling the array_shuffle() function.

Read more

Understanding PostgreSQL’s REGEXP_INSTR() Function

by

In PostgreSQL, the regexp_instr() function returns the starting or ending position of the N‘th match of a POSIX regular expression pattern to a string. If there’s no match, it returns zero.

We pass the string and pattern as arguments. The function also accepts some optional arguments that allow us to be specific with how the function works.

Read more