I'm sorry if this is a duplicate, although I couldn't find an exact answer for this anywhere:
Is there a way to create an array in postgreSQL which contains multiple data types?
I have an column of type
I don't believe there's a way to declare an array with multiple types; however, I think you can accomplish what you are trying to do with a composite type, e.g.,
create type my_item as ( field_1 text, field_2 text, field_3 text, field_4 number );
You could then use this as the column type for your table or even declare a column of arrays of
my_item if that fits your need.