Postgres Pro
Downloads
Home   >   mailing lists

Re: jsonb_array_length: ERROR: 22023: cannot get array length of a scalar - Mailing list pgsql-general

From David G. Johnston
Subject Re: jsonb_array_length: ERROR: 22023: cannot get array length of a scalar
Date
Msg-id CAKFQuwZ7JumHOpbsKH=2qsa6iL2XYnYGz2qYFomXz72sf6j14Q@mail.gmail.com
Whole thread Raw
In response to Re: jsonb_array_length: ERROR: 22023: cannot get array length of a scalar  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view
On Fri, Mar 2, 2018 at 11:48 AM, Alexander Farber <alexander.farber@gmail.com> wrote:
Oops, I've got strings there too - when swapping instead of playing tiles:


​You should probably add:

jsonb_array_length(tiles) > 0

as a check constraint on column
​
David J.

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: jsonb_array_length: ERROR: 22023: cannot get array length of a scalar
Next
From: Adrian Klaver
Date:
Subject: Re: jsonb_array_length: ERROR: 22023: cannot get array length of ascalar