|
|
|
|
|
by VLM
4561 days ago
|
|
This is probably a good discussion point http://www.postgresql.org/docs/9.3/static/functions-aggregat... Not only as an example of "single line in a table" but also as an example where a huge volume would not add much value. I'm struggling at this time to figure out how to produce multiple pages of boilerplate explaining "min()" that would be any more useful than the table. On the other hand the explanation about nulls really sucks. Its important enough to put in the single line. For those too lazy to click and read, when a noob thinks he wants "SUM(bunchastuff)" what he probably wants is along the lines of using COALESCE or a homemade function that smells like COALESCE. There is a meta discussion that whenever NULLs are possible, and its more than just table definitions for example an overactive WHERE clause, then the NULLs will be a PITA. Defensive SQL coding can be tedious. |
|