future-architect/go-twowaysql

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{...}