Hello!
I'm using a postgresql DB and have a column containing arrays (integer[]). Problem is I don't know how to save or update data because of this array column.
I tried a simple
$table->column = [1, 2, 3];
But it doesn't work, I'm getting the following error :
preg_replace(): Parameter mismatch, pattern is a string while replacement is an array
Is there a way to make it work without using raw statements ?
Thank you
Yes, that would work in my case as I have access to the DB.
So I guess there's no easy way to store arrays with Eloquent other than converting the php array to postgresql array when inserting and the other way around when selecting.
Thanks
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community