V
V
Vladimir2017-01-17 17:20:27
PostgreSQL
Vladimir, 2017-01-17 17:20:27

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

2 answer(s)
M
Melkij, 2017-01-17
@Casufi

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

S
SharuPoNemnogu, 2017-01-17
@SharuPoNemnogu

and try? the same will be, except range

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question