Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres stored procedure errs while parsing JSONB object - Mailing list pgsql-sql

From David G. Johnston
Subject Re: Postgres stored procedure errs while parsing JSONB object
Date
Msg-id CAKFQuwYX4zDSBTQrdkoqzPx9BXeYWPKBPgZRBDK83EDHFxWZPg@mail.gmail.com
Whole thread Raw
In response to Postgres stored procedure errs while parsing JSONB object  (Igor Shmukler <igor.shmukler@gmail.com>)
Responses Re: Postgres stored procedure errs while parsing JSONB object
List pgsql-sql
Tree view
On Wednesday, May 20, 2020, Igor Shmukler <igor.shmukler@gmail.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.
 

pgsql-sql by date:

Previous
From: Igor Shmukler
Date:
Subject: Postgres stored procedure errs while parsing JSONB object
Next
From: Igor Shmukler
Date:
Subject: Re: Postgres stored procedure errs while parsing JSONB object