Answer the question
In order to leave comments, you need to log in
How to make a select from a column with an array of numbers?
Good afternoon.
There is a jsonb column, it contains data in the form [1,2,3,10,55], how to search for matching elements? For example find rows that have matches with another array?
So it searches only for strings and only for 1 element, it doesn’t work with integer (What is actually written in the doc - ? Does the string exist as a top-level key within the JSON value?)
SELECT * FROM test WHERE mycolumn ? '1';
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question