Re: Postgres stored procedure errs while parsing JSONB object

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Igor Shmukler <igor(dot)shmukler(at)gmail(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Postgres stored procedure errs while parsing JSONB object
Date: 2020-05-20 15:04:47
Message-ID: CAKFQuwYX4zDSBTQrdkoqzPx9BXeYWPKBPgZRBDK83EDHFxWZPg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wednesday, May 20, 2020, Igor Shmukler <igor(dot)shmukler(at)gmail(dot)com> wrote:

>
> ...
> FOR showing IN SELECT * FROM json_to_recordset(to_json(event_times))
> AS show(id INTEGER,
> times JSONB, startDate DATE, endDate DATE) LOOP
> IF showing.id > 0 THEN
> UPDATE
> event_shows
> SET
> start_date = showing.startDate, end_date = showing.endDate,
> times = showing.times
>
>

Try showing.”startDate” and showing.”endDate” ... (i.e., you need double
quotes around the case-sensitive identifier)

David J.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Igor Shmukler 2020-05-20 15:10:17 Re: Postgres stored procedure errs while parsing JSONB object
Previous Message Igor Shmukler 2020-05-20 14:39:34 Postgres stored procedure errs while parsing JSONB object