On Sat, 31 Aug 2019, Morris de Oryx wrote:
Your tributaries and fish master tables make sense. If I read your code
right, you're grouping by too many columns. I flattened the data into a
survey table for this simple example:
Morris,
I'm still learning about postgres groups. My approach is to
Your tributaries and fish master tables make sense. If I read your code
right, you're grouping by too many columns. I flattened the data into a
survey table for this simple example:
select tributary,
common_name,
scientific_name,
sum(count_value) as fish_seen,
count(cou
On Fri, 30 Aug 2019, John W Higgins wrote:
You are grouping by count_value which means that you are asking the system
to return a row for each different count_value.
John,
I didn't realize this.
So if you remove the f.count_value from the select statement (not the
sum(f.count_value)) - and
