Handle select where in multiple pairs
ma91n opened this issue · 0 comments
ma91n commented
Example
SELECT * FROM t WHERE (col1, col2) IN ( VALUES (val1a, val2a), (val1b, val2b)) ;
https://stackoverflow.com/questions/69263666/select-where-in-multiple-pairs-postgresql
Design Plan
SELECT * FROM t WHERE (col1, col2) IN ( VALUES /*pair*/('aa', 'bb'),) ;
bind parameters is below.
type Pair struct {
Col1 string
Col2 string
}
bindParams := [] Pair{...}