Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

version
PostgreSQL 15.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit

SELECT 1

Create table public.values_with_variable_view( id integer NOT NULL,
    "timestamp" timestamp with time zone NOT NULL,  intvalue bigint);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (1000,'2024-01-04 01:07:10.554192+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (2000,'2024-01-04 01:08:09.267336+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (999,'2024-01-04 01:08:10.554191+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (1999,'2024-01-04 01:09:09.267335+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (998,'2024-01-04 01:09:10.554191+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (1998,'2024-01-04 01:10:09.267335+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (997,'2024-01-04 01:10:10.55419+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (1997,'2024-01-04 01:11:09.267335+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (996,'2024-01-04 01:11:10.55419+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (1996,'2024-01-04 01:12:09.267335+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (995,'2024-01-04 01:12:10.55419+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (1995,'2024-01-04 01:13:09.267334+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (994,'2024-01-04 01:13:10.554189+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (1994,'2024-01-04 01:14:09.267334+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (993,'2024-01-04 01:14:10.554189+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (1993,'2024-01-04 01:15:09.267334+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (992,'2024-01-04 01:15:10.554189+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (1992,'2024-01-04 01:16:09.267334+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (991,'2024-01-04 01:16:10.554188+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (1991,'2024-01-04 01:17:09.267333+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (990,'2024-01-04 01:17:10.554188+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (1990,'2024-01-04 01:18:09.267333+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (989,'2024-01-04 01:18:10.554188+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (1989,'2024-01-04 01:19:09.267333+00',10);
INSERT INTO public."values_with_variable_view"(id, "timestamp",  intvalue) VALUES (988,'2024-01-04 01:19:10.554187+00',10);

select * from values_with_variable_view;

--alternate to make it work with LINQ
select * from values_with_variable_view
  where timestamp > '2024-01-04 01:12:09.267335+00'
  and 
  id > 1996
  order by timestamp, id;

--Keyset (this works)
SELECT *
FROM public.values_with_variable_view
WHERE ( timestamp, id) > ('2024-01-04 01:12:09.267335+00',1996)
ORDER BY ( timestamp, id) asc
LIMIT 100

CREATE TABLE

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

id	timestamp	intvalue
1000	2024-01-04 01:07:10.554192+00	10
2000	2024-01-04 01:08:09.267336+00	10
999	2024-01-04 01:08:10.554191+00	10
1999	2024-01-04 01:09:09.267335+00	10
998	2024-01-04 01:09:10.554191+00	10
1998	2024-01-04 01:10:09.267335+00	10
997	2024-01-04 01:10:10.55419+00	10
1997	2024-01-04 01:11:09.267335+00	10
996	2024-01-04 01:11:10.55419+00	10
1996	2024-01-04 01:12:09.267335+00	10
995	2024-01-04 01:12:10.55419+00	10
1995	2024-01-04 01:13:09.267334+00	10
994	2024-01-04 01:13:10.554189+00	10
1994	2024-01-04 01:14:09.267334+00	10
993	2024-01-04 01:14:10.554189+00	10
1993	2024-01-04 01:15:09.267334+00	10
992	2024-01-04 01:15:10.554189+00	10
1992	2024-01-04 01:16:09.267334+00	10
991	2024-01-04 01:16:10.554188+00	10
1991	2024-01-04 01:17:09.267333+00	10
990	2024-01-04 01:17:10.554188+00	10
1990	2024-01-04 01:18:09.267333+00	10
989	2024-01-04 01:18:10.554188+00	10
1989	2024-01-04 01:19:09.267333+00	10
988	2024-01-04 01:19:10.554187+00	10

SELECT 25

id	timestamp	intvalue

SELECT 0

id	timestamp	intvalue
995	2024-01-04 01:12:10.55419+00	10
1995	2024-01-04 01:13:09.267334+00	10
994	2024-01-04 01:13:10.554189+00	10
1994	2024-01-04 01:14:09.267334+00	10
993	2024-01-04 01:14:10.554189+00	10
1993	2024-01-04 01:15:09.267334+00	10
992	2024-01-04 01:15:10.554189+00	10
1992	2024-01-04 01:16:09.267334+00	10
991	2024-01-04 01:16:10.554188+00	10
1991	2024-01-04 01:17:09.267333+00	10
990	2024-01-04 01:17:10.554188+00	10
1990	2024-01-04 01:18:09.267333+00	10
989	2024-01-04 01:18:10.554188+00	10
1989	2024-01-04 01:19:09.267333+00	10
988	2024-01-04 01:19:10.554187+00	10

SELECT 15