Tutorial by Examples

Preparing data: create table wf_example(i int, t text,ts timestamptz,b boolean); insert into wf_example select 1,'a','1970.01.01',true; insert into wf_example select 1,'a','1970.01.01',false; insert into wf_example select 1,'b','1970.01.01',false; insert into wf_example select 2,'b','1970.01.01...

here you can find the functions. With the table wf_example created in previous example, run: select i , dense_rank() over (order by i) , row_number() over () , rank() over (order by i) from wf_example The result is: i | dense_rank | row_number | rank ---+------------+------------+-...