Re: how to add asterisk on count when using partition over

2019-05-23 Thread genc
Ah figured out. .select_append { Sequel.function(:count).*.over(partition: quiz_snapshot. get_text('email')).as(:count) } On Friday, May 24, 2019 at 2:03:54 AM UTC+3, genc wrote: > > I have this sql line: > > count(*) OVER (PARTITION BY sender->>'email') AS "count" > > > And I translated to

how to add asterisk on count when using partition over

2019-05-23 Thread genc
I have this sql line: count(*) OVER (PARTITION BY sender->>'email') AS "count" And I translated to this: .select_append { count.function.over(partition: sender.get_text('email')).as (:count) } But this gives count() instead of count(*) This causes an error. How can i add asterisk to the