If you’re getting an error that starts with “sample size must be between…” when using the array_sample() function in PostgreSQL, it’s probably because your second argument is either a negative value, or it’s larger than the number of elements in the array.

The second argument must be no less than zero, and it can’t be any larger than the number of elements in the array.

To fix this error, be sure that your second argument is greater than zero and less than or equal to the number of elements in the array at the first argument.

Continue reading →

If you’re getting a PostgreSQL error that reads “function generate_subscripts(integer, integer) does not exist“, it’s probably because your first argument is not an array. This specific error message implies that the first argument is an integer, but we’d get a similar error when passing a numeric argument.

The first argument for this function must be an array.

To fix this error, be sure that your first argument to generate_subscripts() is an array.

Continue reading →

If you’re getting an error that reads “invalid input syntax for type integer…” when using the array_sample() function in PostgreSQL, it’s probably because your second argument is not an integer.

The second argument for this function must be an integer.

To fix this error, be sure that your second argument to array_sample() is an integer.

Continue reading →

If you’re getting an error that reads “could not determine polymorphic type because input has type unknown” when using the array_sample() function in PostgreSQL, it’s probably because your first argument is of the wrong type.

The array_sample() function requires an array as its first argument. Passing a non-array value will result in an error. The actual error can vary, depending on the argument you pass, but either way, the error is usually due to a non-array being passed.

To fix this error, be sure to pass an array as the first argument when calling the array_sample() function.

Continue reading →