Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Using the map type, we can set specific key+value pairs individually:

      UPDATE users SET todo['first'] = 'value1'  WHERE user_id = 'frodo';
      UPDATE users SET todo['second'] = 'value2'  WHERE user_id = 'frodo';
      

      There is no analogous way to request specific properties from a map by key. This is significant when a map could potentially store many properties from which only a subset is required.

      Ideally, the query syntax would reflect the mutation syntax, as in:

      SELECT todo['first'], todo['second'] FROM users WHERE user_id = 'frodo';
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                frkline Frank-Robert Kline
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: