search

Masterminds / squirrel

Fluent SQL generation for golang
Other
6.67k stars 458 forks source link

Syntax Error with `squirrel.Or` in Postgres #358

Open maxlambrecht opened 1 year ago

maxlambrecht commented 1 year ago

Problem

I have encountered a syntax error when using the squirrel.Or construct with Postgres:

squirrel.Or{
    squirrel.Eq{"field_1": value},
    squirrel.Eq{"field_2": value},
}

The following error occurs: "ERROR: syntax error at or near 'OR' (SQLSTATE 42601)"

Workaround:

squirrel.Or{
    squirrel.Expr("field_1 = $1 OR field_2 = $2", value, value),
}

Additional Information:

Postgres version: 15 Squirrel version: v1.5.4