1 Matching Annotations
  1. Jun 2021
  2. dba.stackexchange.com dba.stackexchange.com
    PostgreSQL joining using JSONB
    1
    1. TylerRick 04 Jun 2021
      Use the -> operator instead of ->> in the reference to children. The way you have it, you'd first cast json / jsonb to text and then back to json.
      distinction PostgreSQL: operators PostgreSQL: json
    Visit annotations in context

    Tags

    Annotators

    URL

    dba.stackexchange.com/questions/83932/postgresql-joining-using-jsonb