golang syntax error at or near "$1" in postgres using gorm

Question

I am trying to find multiple users based on their name. I am using gorm as follow:

err := db.Where("username IN ?", []string{"name1", "name2"}).Find(&users).Error

But the generated query is:

SELECT * FROM "users_customer"."user" WHERE (username IN 'name1','name2')

when the correct query should be:

SELECT * FROM "users_customer"."user" WHERE username IN ('name1','name2')

So the error pq: syntax error at or near "$1" is thrown. I use the same syntax as stated in the doc, which is db.Where("name IN ?", []string{"jinzhu", "jinzhu 2"}).Find(&users) but don't know why in my case it doesn't work.

Did you try IN (?) inside your String?

user330315
– user330315

2021-12-14 11:42:05 +00:00
Commented Dec 14, 2021 at 11:42 — user330315
– user330315, Commented Dec 14, 2021 at 11:42
@a_horse_with_no_name. problem solved. Thank you.

Thuan Nguyen
– Thuan Nguyen

2021-12-14 12:25:09 +00:00
Commented Dec 14, 2021 at 12:25 — Thuan Nguyen
– Thuan Nguyen, Commented Dec 14, 2021 at 12:25

Ashutosh Singh · Accepted Answer · 2021-12-14 11:42:34Z

2

Gorm by default ad ' this at each side and it does not add brackets ().

You should add it manually like this :

    names := []string{"name1", "name2"}

    commaSep := "'" + strings.Join(names, "', '") + "'"
    err := db.Where("username IN (?)", commaSep).Find(&users).Error

You can run it here : https://go.dev/play/p/ox3H2gL1yek

OR

err := db.Where("username IN (?)", []string{"name1", "name2"}).Find(&users).Error

answered Dec 14, 2021 at 11:42

Ashutosh Singh

1,1226 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

golang syntax error at or near "$1" in postgres using gorm

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