Re: adding more conditions on inner join when using recursive

2018-11-15 Thread Jeremy Evans
On Thursday, November 15, 2018 at 12:43:03 AM UTC-8, genc wrote: > > Hi Jeremy, > > I want to add more conditions to inner join after ON but it appends and > treat as array instead of merging conditions. > > Let me show you the full query builder: > > DB[:full_paths]. > select(:id, :subject).

Re: adding more conditions on inner join when using recursive

2018-11-15 Thread genc
Ah, I merged them with & Sequel.expr { x[:user_id] =~ 4 } & ... On Thursday, November 15, 2018 at 11:43:03 AM UTC+3, genc wrote: > > Hi Jeremy, > > I want to add more conditions to inner join after ON but it appends and > treat as array instead of merging conditions. > > Let me show you the

adding more conditions on inner join when using recursive

2018-11-15 Thread genc
Hi Jeremy, I want to add more conditions to inner join after ON but it appends and treat as array instead of merging conditions. Let me show you the full query builder: DB[:full_paths]. select(:id, :subject). cross_join(:pattern). where{{:idx=>cardinality(:pattern)}}. with(:pattern,