Lines Matching refs:where

110   unset -nocomplain where
127     set where {}
131       lappend where mn$j>=$mn mx$j<=$mx
133     set where "WHERE [join $where { AND }]"
135       list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
136     } [list $where [db eval "SELECT id FROM bx $where ORDER BY id"]]
140     set where {}
144       lappend where mx$j>=$mn mn$j<=$mx
146     set where "WHERE [join $where { AND }]"
148       list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
149     } [list $where [db eval "SELECT id FROM bx $where ORDER BY id"]]
154     set where {}
156       lappend where mn$j>-10000 mx$j<10000
161       lappend where mn$j>=$mn mx$j<=$mx
163     set where "WHERE [join $where { AND }]"
165       list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
166     } [list $where [db eval "SELECT id FROM bx $where ORDER BY id"]]
171     set where {}
173       lappend where mn$j>=-10000 mx$j<=10000
178       lappend where mx$j>$mn mn$j<$mx
180     set where "WHERE [join $where { AND }]"
182       list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
183     } [list $where [db eval "SELECT id FROM bx $where ORDER BY id"]]
187     set where {}
191       lappend where mn$j>=$mn mx$j<$mx
194       lappend where mn$j>=-10000 mx$j<10000
196     set where "WHERE [join $where { AND }]"
198       list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
199     } [list $where [db eval "SELECT id FROM bx $where ORDER BY id"]]
203     set where {}
207       lappend where mx$j>$mn mn$j<=$mx
210       lappend where mx$j>-10000 mn$j<=10000
212     set where "WHERE [join $where { AND }]"
214       list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
215     } [list $where [db eval "SELECT id FROM bx $where ORDER BY id"]]
217     # Do a contained-in query with surplus contraints where the 
220     set where {}
226       lappend where mn$j>=$mn1 mn$j>$mn2 mx$j<$mx1 mx$j<=$mx2
228     set where "WHERE [join [scramble $where] { AND }]"
230       list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
231     } [list $where [db eval "SELECT id FROM bx $where ORDER BY id"]]
233     # Do an overlaps query with surplus contraints where the
236     set where {}
242       lappend where mx$j>=$mn1 mx$j>$mn2 mn$j<$mx1 mn$j<=$mx2
244     set where "WHERE [join [scramble $where] { AND }]"
246       list $where [db eval "SELECT id FROM rx $where ORDER BY id"]
247     } [list $where [db eval "SELECT id FROM bx $where ORDER BY id"]]