Re: jsonb_array_length: ERROR: 22023: cannot get array length of ascalar

On 03/02/2018 06:42 AM, Alexander Farber wrote:
> Hi Adrian, I 100% agree that nobody except me should debug my huge 
> stored function, but if you look at my PostgreSQL 10.3 log -
> 

Another thought, in :

2018-03-02 15:30:33.646 CET [16693] LOG:  duration: 0.058 ms  bind 
<unnamed>: SELECT out_uid  AS uid,  out_fcm  AS fcm,  out_apns AS apns, 
out_adm  AS adm,  out_body AS body  FROM words_play_game($1::int, 
$2::int, $3::jsonb)

where is $3::jsonb coming from?


-- 
Adrian Klaver
adrian.klaver@aklaver.com