You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
run TiPG's filters on a table to get a subset of data
Perform some sort of calculation on the results - say, MAX(area), just COUNT(*) and return just a single row with those results?
I've attempted to do this with a custom function, but it looks like the filters are applied after function is run and the function must therefore return all rows. I just want a single tuple returned in this case, not the full set.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Is there a way to
MAX(area)
, justCOUNT(*)
and return just a single row with those results?I've attempted to do this with a custom function, but it looks like the filters are applied after function is run and the function must therefore return all rows. I just want a single tuple returned in this case, not the full set.
Beta Was this translation helpful? Give feedback.
All reactions