Hello Marcio Andrey Oliveira and Jeremy.
Thank you for your reply. I missed about 'Sequel.as'
2014年9月16日火曜日 0時11分47秒 UTC+9 Jeremy Evans:
>
> On Monday, September 15, 2014 1:57:17 AM UTC-7, Hiroyuki Sato wrote:
>>
>> Hello members.
>>
>> My goal
>> I would like to execute the following sql with sequel.
>>
>> select path, max(mtime) as mtime, type from (
>>
>> select path, mtime, 'server' as 'type'
>> from hoge
>> union
>> select path, mtime, 'client' as 'type'
>> from fuga
>> ) as tmp
>> group by path;
>>
>>
>>
> First, your SQL is not standard SQL as you are selecting non-aggregate
> expressions that you are not grouping by. You probably want to group by
> path and type, or not select type. I'm going to assume you want to group
> by path and type. It's also nonstandard to use a string instead of a
> identifier as an alias, but that's just a syntax issue. Anyway, here's how
> you could represent the query using the Sequel DSL:
>
> ds = DB.select(:path, :mtime)
>
> ds.select_append(Sequel.as('server', :type)).from(:hoge).
> union(ds.select_append(Sequel.as('client', :type)).from(:fuga),
> :alias=>:tmp).
> select_group(:path, :type).
> select_append{max(:mtime).as(:mtime)}
>
> 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.
