On 9 juil. 2014, at 17:10, Jeremy Evans <[email protected]> wrote:
> On Wednesday, July 9, 2014 7:07:43 AM UTC-7, Nicolas Goy wrote:
> I have been trying to do the following SQL with sequel (PostgreSQL 9.3):
>
> delete from events evt
> using (
> select id, row_number() over (partition by (entity_type, entity_id) order
> by at desc) as rn from events
> ) evt2
> where
> evt2.rn > 1
> and
> evt2.id = evt.id
>
>
> But I can't figure how to generate it.
>
> DB[:events___evt,
> DB[:events].select(:id){row_number{}.over(:partition=>[:entity_type,
> :entity_id],
> :order=>Sequel.desc(:at)).as(:rn)}.as(:evt2)].where(:evt2__id=>:evt__id){evt2__rn
> > 1}
Wonderful, thanks
--
Nicolas Goy
Programmer
http://kuon.goyman.com
--
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.
