jsonb vs jsonb[] for multiple addresses for a customer

by

Use a jsonb (not jsonb[]!) column with the structure like this:

select
'[{
        "adresse_line-1": "a11",
        "adresse_line-2": "a12",
        "postalcode": "code1"
    },
    {
        "adresse_line-1": "a21",
        "adresse_line-2": "a22",
        "postalcode": "code2"
    }
]'::jsonb;

Though, a regular table related to the main one is a better option.

Why not jsonb[]? Take a look at JSON definition:

JSON is built on two structures:

  • A collection of name/value pairs. In various languages, this is realized as an object, record, struct, dictionary, hash table, keyed list, or associative array.
  • An ordered list of values. In most languages, this is realized as an array, vector, list, or sequence.

In a jsonb column you can therefore store an array of objects. Attempts to use the array of jsonb are probably due to misunderstanding of this type of data. I have never seen a reasonable need for such a solution.

More Related Contents:

  1. Using jsonb_set() for updating specific jsonb array value
  2. Can PostgreSQL index array columns?
  3. Unnest multiple arrays in parallel
  4. Return rows matching elements of input array in plpgsql function
  5. Can PostgreSQL have a uniqueness constraint on array elements?
  6. Loop over array dimension in plpgsql
  7. Unnest array by one level
  8. Compare arrays for equality, ignoring order of elements
  9. Iterating over integer[] in PL/pgSQL
  10. Not all properties displayed
  11. Query for array elements inside JSON type
  12. Remove an element from a Bash array
  13. Declare a constant array
  14. How to query a json column for empty objects?
  15. Django JSONField inside ArrayField
  16. Multidimensional array with different lengths
  17. Malloc a 2D array in C [duplicate]
  18. Find the 2nd largest element in an array with minimum number of comparisons
  19. I am getting error “array.sh: 3: array.sh: Syntax error: “(” unexpected”
  20. In Swift, an efficient function that separates an array into 2 arrays based on a predicate
  21. Is there a way to instantly generate an array filled with a range of values in Swift?
  22. Turn Excel range into VBA string
  23. Generic function to sort array of class or struct by properties in Swift
  24. Powershell: Piping output of pracl command to array
  25. Pass array literal to PostgreSQL function
  26. How do I assign ls to an array in Linux Bash?
  27. VBA Excel large data manipulation taking forever
  28. How do I iterate through each element in an n-dimensional matrix in MATLAB?
  29. Dynamically Dimensioning A VBA Array?
  30. Simple VBA array join not working

Leave a Comment