search

zompinc / efcore-extensions

Provides window (analytics) functions and binary functions for EF Core. Providers: SQL Server, SQLite, Postgres.
MIT License
60 stars 6 forks source link

Empty over clause does not work #8

Closed virzak closed 1 year ago

virzak commented 1 year ago

Thanks for the PR @denis-tsv.

The reason why it wasn't implemented in the first place was because SQL Server needs at least one argument for this to work. Will look into how this can be processed with PostgreSQL,

denis-tsv commented 1 year ago

It the lates version of SQL Server partition by and order by are optional for over https://learn.microsoft.com/en-us/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-ver16

denis-tsv commented 1 year ago

In postgres over without parameters also OK https://www.postgresql.org/docs/current/tutorial-window.html