Is it better to use tables instead of arrays field type in PostgreSql when arrays do not exceed 50 elements?

I avoid arrays for 2 reasons:

  • by storing more than one attribute value in a cell you violate the first normal form (theoretical);
  • you have to perform some extra, non-SQL related, processing each time you need to work with individual elements of the arrays (practical, but a direct consequence of the theoretical one)

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)