Re: [postgis-users] A function to find errors in groups in a table

Use a window function to find where outflow =< inflow with the window on the nodeid. On Thu., Jun. 9, 2022, 5:28 a.m. Shaozhong SHI, wrote: > There is a table full of grouped values like the following > > nodeid link_type primary > 11 outflowlink 1 > 11

[postgis-users] A function to find errors in groups in a table

There is a table full of grouped values like the following nodeid link_type primary 11 outflowlink 1 11 inflowlink 1 11 outflowlink 2 Primary of 1 indicates a primary water course. Primary of 2 indicates a secondary water course.