Morning all. There was a tricky one posted last night - I had a go but could only get so far! Any takers? I'm off for my walk - weather overcast, but warm enough and it doesn't look like rain! :-) For now!
Using postgresql 9.6.
The table has user sessions and I need distinct non overlapping sessions printed.
CREATE TABLE SESSIONS(
id serial NOT NULL PRIMARY KEY,
ctn INT NOT NULL,
day DATE NOT NULL,
f_time TIME(0) NOT NULL,
l_time TIME(0)...
There are standard solutions available to solve this problem by Itzik Ben-Gan and others.
There is a question over the precise meaning of "maximum number of concurrent logged in distinct users". If this means that each user might have multiple concurrent sessions, and you only want to count one p...
Using postgresql 9.6.
The table has user sessions and I need distinct non overlapping sessions printed.
CREATE TABLE SESSIONS(
id serial NOT NULL PRIMARY KEY,
ctn INT NOT NULL,
day DATE NOT NULL,
f_time TIME(0) NOT NULL,
l_time TIME(0)...
