Answer the question
In order to leave comments, you need to log in
Is there an equivalent of Oracle's count in PostgreSQL window functions?
I know that there
are window functions in PostgreSQL, but I did not find the banal count in the list of functions
.
SQL?
Answer the question
In order to leave comments, you need to log in
postgresql does not explicitly distinguish between aggregate and window functions. As a window function, you can use any aggregating function (except those specified in the list (or implemented as) Ordered-Set and Hypothetical-Set).
https://www.postgresql.org/docs/current/static/fun...
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question