Hello Jeremy. Thank you for replying. I'll try it.
2015年11月6日金曜日 2時33分22秒 UTC+9 Jeremy Evans: > > On Thursday, November 5, 2015 at 3:14:31 AM UTC-8, Hiroyuki Sato wrote: >> >> Hello >> >> Could you tell me how to write ``like s.col1 || '%'`` join statement with >> sequel? >> >> I would like to write following query with sequel. >> I wrote it except ``like join`` statement. >> >> * DB: PostgreSQL 9.4.5 >> * Sequel: 4.28.0 >> >> Thank you for your advice. >> >> SELECT col1, col2,count(*) >> FROM ( SELECT s.col1,col2 >> FROM data_table1 l, >> rel_table s >> WHERE l.path like s.col1 || '%' >> UNION ALL >> SELECT s.col1,col2 >> FROM data_table2 l, >> rel_table s >> WHERE l.path like s.col1 || '%' >> ) as test GROUP BY col1,col2; >> >> >> >> db[:data_table1].select(:col1,:col2) >> .union(db[:data_table2].select(:col1,:col2),:all=>true) >> .group_and_count(:col1,:col2) >> > > db[:data_table1___l, :rel_table___s].select(:s__col1,:col2). > where(Sequel.like(:l__path, Sequel.join([:s__col1, '%']))). > union(db[:data_table2___l, > :rel_table___s].select(:s__col1,:col2).where(Sequel.like(:l__path, > Sequel.join([:s__col1, > '%']))),:all=>true). > group_and_count(:col1,:col2) > > Thanks, > Jeremy > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
