postgresql will not save array of empty arrays

Question

A user model has a goal field that is an array:

t.integer "goal", default: [], array: true

A valid entry for goal is [[],[],[]]. If I do

Match.create(goal: [[],[],[]])

I get an exception:

ActiveRecord::StatementInvalid: PG::InvalidTextRepresentation: ERROR:  malformed array literal: "{{},{},{}}"
DETAIL:  Unexpected "}" character.

I know that I can work around this by saving it as goal: [], but I lose information about the number of sub-arrays. Is there a way to fix this?

TomDunning · Accepted Answer · 2019-03-18 20:17:08Z

1

You’ve gone from trying to store an array of numbers to an array of fixed length which includes null values or even sub arrays. Therefore, a t.integer field is no good. You need to use a t.jsonb or t.json field.

See the Postgres docs on JSON datatypes

answered Mar 18, 2019 at 20:17

TomDunning

4,8771 gold badge28 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgresql will not save array of empty arrays

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related