Hello !
When I try to insert an object with an array, I see that the query sent to Postgre is not valid.
INSERT INTO ... '["tag1", "tag2"]' is generated instead of INSERT INTO ... '{"tag1", "tag2"}'
Do you have any idea what went wrong ?
Thank's :)
gmolveau
All 7 comments
That looks like JSON, you probably need to add ,array tag to the struct field.
vmihailenco
on 8 Nov 2018
I've added sql:",array" to the field of my struct, but the error is still there.
gmolveau
on 8 Nov 2018
Okay, now it is time to create a small program that reproduces the problem.
vmihailenco
on 8 Nov 2018
Same here trying to find the reason, seems it ignores sql:",array" somehow
tpoxa
on 8 Nov 2018
Can you please re-open the issue @vmihailenco ?
Here's a small program that reproduces the problem.
https://github.com/gmolveau/go-pg-bug
gmolveau
on 9 Nov 2018
You should fix tags in you example json:"tags,omitempty" sql:",array".
vmihailenco
on 9 Nov 2018
Oh... well... that was it ¯_(ツ)_/¯ Thank's for your help !
gmolveau
on 9 Nov 2018
Related issues
l0gicgate
·
5Comments
kieusonlam
·
6Comments
m-kad
·
3Comments
eicca
·
3Comments
willsr
·
5Comments
Most helpful comment
You should fix tags in you example
json:"tags,omitempty" sql:",array".