You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
with data
as (
select
row(sektor, row, scene1, scene2) block
from d
)
select
case
when lag (block) over(o) is distinct from block
and lead(block) over(o) is distinct from block
It's probably not possible to emulate this in other databases, if it isn't natively supported.
The text was updated successfully, but these errors were encountered:
As can be seen in this blog post, PostgreSQL allows for
ROW
types to be passed toLEAD()
andLAG()
window functions:http://blog.jooq.org/2014/04/15/how-to-do-this-with-sql-of-course/
Example:
It's probably not possible to emulate this in other databases, if it isn't natively supported.
The text was updated successfully, but these errors were encountered: