« first day (3854 days earlier)      last day (88 days later) » 

4:28 AM
@HannahVernon It was telling me that "Please avoid extended discussions in comments..." - so, I hit the link but it just, as I said, dropped me back to the start of the question. But it looks like @bbaird might have rendered further chat moot! :-)
 
 
1 hour later…
5:39 AM
@Vérace feel free to remove/flag any comments that are no longer required
 
 
2 hours later…
7:46 AM
@Vérace Could have been a couple of things. Hard to say for sure now. My guess would be the migration from another site got in the way.
 
8:46 AM
@HannahVernon done, as best I can. It's tricky though. The question is quite involved (which is why I like it! :-) ), but the OP hasn't come back with some responses. I'm not sure if @bbaird 's answer covers all the bases either - it certainly looks impressive, and I'd like to take the time to study it! The problem is that we're undergoing a heatwave here in Ireland (> 30C!!!) and listening to news/politics on the radio in the sun is v. pleasant-plus, try viewing a screen in bright sunshine!
Even having to concentrate in 30C is, well, meh...
@PaulWhite - might be worth reporting as some sort of edge-case bug?
Far more important - db<>fiddle is still down! I bought a disposable credit card specifically to make a donation (don't like the idea of recurring payments and then having to cancel), but you have to dance through lots of hoops to set it up, so I haven't done it yet... It's a bit like an eye infection - you only realise how important something is when it's impaired/removed.
Oh, almost forgot - A chairde - Morning all!
 
 
4 hours later…
12:40 PM
@Vérace that's awesome, thanks. That's the main reason why I didn't delete all the commentary at first :-)
 
1:13 PM
@Vérace I have only one question for you:
wtf is tabitibo?
 
 
1 hour later…
2:34 PM
@ypercubeᵀᴹ - does the link not explain it? It has to do with groupings and row_number() - may not be completely appropriate in this case - but hey, it's a cool word! :-) And appropriate for current times! Japanese for "traveller"...
 
3:19 PM
was afraid to click on that link ;)
looks like a method that can be applied to certain gaps and islands problems, ok.
 
 
1 hour later…
4:22 PM
@ypercubeᵀᴹ which seems to apply to OP's problem - at least to an extent! :-) I'm not sure that @bbaird 's solution can't also be written that way - but, as I said, "canicule obilge" - too much effort at the moment! Downstairs talking with Mum... felt heat-stroke kicking in... lovely - great practice for when I go to continental Europe...
 
4:35 PM
are you flying to the Mediterranean seasides?
 
4:57 PM
@ypercubeᵀᴹ depends - my fiancee wants to go to Florence - I'd prefer Croatia (inland).... Because of my Mother's advanced years, I'd prefer risk reduction...
 
 
3 hours later…
7:43 PM
Would this question be on topic here? And is it a sensible question?
 
8:34 PM
@FaheemMitha this is a kind of "off-topic - anything goes, chat site"... if you want to ask a "proper" database-related question, then it should be asked on the main site IMHO.
 

« first day (3854 days earlier)      last day (88 days later) »