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
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