The Heap™ – Consultancy ©®

« first day (3500 days earlier) ← previous day next day → last day (1354 days later) »

Vérace

6:54 AM

Morgen...

McNets

7:06 AM

Morning

Vérace

7:36 AM

This should have been asked on the main site!

yesterday, by matmany

Hi! i using postgre, and i would like to sum every single value from my case! but when i try i get this error: SQL Error [42803]: ERROR: aggregate function calls cannot be nested
Position: 125
this is my query:

This user has asked no questions!

dba.stackexchange.com/users/213443/matmany?tab=topactivity

Nor have they answered anything! @AndriyM 's answer would be a contribution, rather than being unreachable here! Using The Heap as a back channel to get answers should be discouraged and the user pointed to the main site!

Thoughts from fellow Heapers?

John aka hot2use

8:12 AM

Morning

Andriy M

8:27 AM

Morning

Andriy M

8:45 AM

The question was a bit vague, in the sense that the logic wasn't really described in any way, so my interpretation of what the query was doing was rather a guess.

It was also very late at night for me (or should I say very early in the morning), so I was a little too groggy to want to browse the main site in search of questions (though apparently not groggy enough to stop my curiosity about the problem itself)

So, at the risk of sounding even more encouraging of that sort of behaviour rather than discouraging it, I'd say there were a couple factors in favour of posting the question here.

2 hours later…

Peter Vandivier

11:14 AM

https://dba.stackexchange.com/questions/239180/find-ancestry-from-json#comment471849_239206

@MichaelGreen i gave up trying to get a "handle for all possible pathing types" in sql server after a while from this question, but if the "in-general" concept still interests you at all, i had quite a bit of fun with it over on TA not too long ago - https://topanswers.xyz/nix?q=888

5 hours later…

bbaird

3:49 PM

morning

Tom V

Thanks @bbaird , I have added some more information, changed 1st and 2nd points, and removed the 4th point. Currently using mongo is compulsorily required :/ — Priyadarshan Vijay 4 mins ago

Ouch

bbaird

Ouch indeed.

Fun fact, when I was in college, before I knew anything, I built something in google sheets to reconcile bills among my housemates. It... worked?

6 hours later…

billinkc

9:49 PM

If a user has a questionable name, what happens if you flag them for review or whatever the process is? Do they just have them change the name or does the account get killed out?

I see meta.stackoverflow.com/questions/285204/flag-user-profile but doesn't really call out what happens

2 hours later…