knvjun
Ecto - Multidimensional Array?
Hi Elixir community!
I’m trying to add a column with a two dimensional array type to database.
Here’s my migration.
def change do
alter table(:decisions) do
add :sequence, {:array, {:array, :string}}
end
end
with this, i don’t get error running migration.
Here’s my schema
schema "decisions" do
...
field :sequence, {:array, {:array, :string}}
timestamps()
end
But when i try to save this value [["C83", "N51", "G3"], ["K22", "B17"], ["W46", "N14"]] to field :sequence, I got this error
(ArgumentError) nested lists must have lists with matching lengths
(postgrex) lib/postgrex/extensions/array.ex:63: anonymous fn/6 in Postgrex.Extensions.Array.encode/4
How do I put matching lists with matching lengths to :sequence column? Any help is appreciated.
Thank You.
Marked As Solved
NobbZ
All of the inner lists, need to have the same length. Zour first list has three elements, the remaining ones have only 2.
Either make all lists of length 3 or all of them of length 2.
Also Liked
alco
I’m not so sure about that:
CREATE TEMPORARY TABLE sal_emp (
name text,
pay_by_quarter integer[],
schedule text[][]
);
# CREATE TABLE
INSERT INTO sal_emp
VALUES ('Bill',
'{10000, 10000, 10000, 10000}',
'{{"meeting", "lunch"}, {"meeting"}}');
# ERROR: malformed array literal: "{{"meeting", "lunch"}, {"meeting"}}"
# LINE 4: '{{"meeting", "lunch"}, {"meeting"}}');
# ^
# DETAIL: Multidimensional arrays must have sub-arrays with matching dimensions.
INSERT INTO sal_emp
VALUES ('Bill',
'{10000, 10000, 10000, 10000}',
'{{"meeting", "lunch"}, {"lunch", "meeting"}}');
# INSERT 0 1
Phillipp
Out of curiosity, what is the reason for that requirement?
mudasobwa
I am also interested in this. AFAIK, PostgreSQL is fine with arbitrary length lists.
mudasobwa
Indeed. I have re-checked myself; it turns out the lengths of sub-arrays are to be the same. Thanks.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
We build reliable cloud platforms for business-critical systems.
Categories:
Sub Categories:
Forums
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"