@billinkc St Stephan is today, isn't it?

@ypercubeᵀᴹ St. Stephen's Day! The first Martyr - Western calendar feast day - 26th of December - which is a bank holiday here and the authorities are so nice that, since it falls on a Saturday, the bank holiday goes to Monday! Yaay! It is the feast of St. Stephen in the Eastern Orthodox calendar - but I'm not sure if that's the Eastern Orthodox Liturgical Calendar or the Gregorian one!

@ypercubeᵀᴹ but with your Athenian roots/location, you'll know all about that!

*here for me being Dublin!

@ypercubeᵀᴹ - from here - if I had a € for every time an OP has written the following(or similar), I'd be a wealthy man! "hate to keep changing the question but you query while is the closest answer, is missing when there is same rows but member count is different (see group 8)"... difficult to stay away! :-)

Just to be clear - when I said above that it "is the feast of St. Stephen in the Eastern Orthodox calendar" - I meant Dec. 27th!

General question fellow Heapers - where's the best place to ask about regular expressions? I've run into a roadblock and am stuck! Would it be DBA.se, Unix & Linux or SuperUser? Or elsewhere?

@Vérace correct, St Spephen is Dec 27 in both of them. But for one calendar, Dec 27 is today and for the other Dec 27 is 13 days from now ;)

I just wondered why Orthodox and Catholics decided to celebrate St Stephen with 1 day apart ...

@ypercubeᵀᴹ - indeed, that's why the October Revolution actually happened in November - got that one in a Uni quiz for a tiebreak one time! :-)

* That's November for me!

it was still October in Russia ;)

Indeed!

@ypercubeᵀᴹ Any input on the regex question?

I quite understand why!

But they are very powerful!

@Vérace I edited the answer for the "grouping" question.

You don't need to delete it. If you feel you don't want your name attached to it, you can make it a Community wiki answer.

@ypercubeᵀᴹ "You don't need to delete it. If you feel you don't want your name attached to it, you can make it a Community wiki answer" - I'll do that - I very much appreciate your input and your SQL skills are orders of magnitude above mine, but I cannot (will not/do not want to) claim contributions which are not my own. I've read your profile and I appreciate why you're not answering - but I don't want to be a sock-puppet by proxy :-) No offence meant - or taken, I hope! :-)

@ypercubeᵀᴹ Are you saying that if one makes an answer a Community Wiki, you don't get credit?

@ypercubeᵀᴹ I'm totally OK with not getting Unicorn points for an answer which isn't my own!

@ypercubeᵀᴹ - I have made the answer into a Community Wiki! Thanks for all the input - I'll spend the New Year analysing it and getting to grips with the finer points exposed by your work: Nollaig shona dhuit [Orthodox] agus Athbhliain Faoi Mhaise dhuit - Happy Christmas and a Happy New Year [both Frankish and Orthodox]! :-)) - but one can wish (at least here) "Happy Christmas" till ~ 01/02 - Jan (Gregorian/Western calendar).

@Vérace you don't points when it is upvoted.

Your name is still there as the original poster but so are all the editors if one looks at the history of the post.

@ypercubeᵀᴹ - yep, saw that, thanks! That's fine by me - I like the warm fuzzy feeling (tm) I get when I answer a question off my own bat, however taking credit for the work of a third party is not me! Again, I understand/symptathise with your rationale - it's just a "hill I chose not to die on"... Best...

I've learnt a lot here, not least from yourself - so, as long as it's good for me...

* "that's NOT a hill I choose to die on"!

@ypercubeᵀᴹ - maybe you should tell the OP that you hate changing the answer so much! :-)

I realized - a bit after originally posting here - that my first and second original queries were not equivalent and suspected he wanted exact division.

which is always harder and much more complicated

changing the topic to different kind of fun: ;)

twitter.com/TrekOnTheTube/status/1342970401484378118

@Vérace what flavor of regex (or what O/S, language, etc)

@Vérace not as much as I "hate hats" ;)

@MaxVernon Well, it's a question concerning PostgreSQL (my fave DB) and MySQL (not my fave DB) - O/S - all, language SQL - REGEXP_REPLACE/MATCH/LIKE... just back from a crispy walk along two piers, brrr.... sitting down to dinner in about 30 mins, prepared by fascist (err... very nice...) brother-in-law - der Küche-Führer - you can guess how he is when it comes to the kitchen! :-)

Morning