public inbox for [email protected]
help / color / mirror / Atom feedFrom: Shaozhong SHI <[email protected]>
To: Pgsql-general <[email protected]>
Subject: A function to find errors in groups in a table
Date: Thu, 9 Jun 2022 14:37:54 +0100
Message-ID: <CA+i5JwboSVnpFO6cvPP169gw-OXWVa5jQ34FXdk54t+L54h6Aw@mail.gmail.com> (raw)
In-Reply-To: <CA+i5JwZCt0c1V-LexLo50Oa+r_UVLM26ZQ4pqq2d9XYaBebKjA@mail.gmail.com>
References: <CA+i5JwZ1y=KNn8uJr_DLe2LZCeLxVxY0osHBVoaELUVC=JWr6A@mail.gmail.com>
<CA+i5JwZCt0c1V-LexLo50Oa+r_UVLM26ZQ4pqq2d9XYaBebKjA@mail.gmail.com>
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.
Obviously, one of the out flow links is an error, as its primacy value is
2. It is wrong that water flows from a primary water course into a
secondary water course.
How can a function can be designed to find and report such errors?
Regards,
David
view thread (5+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: A function to find errors in groups in a table
In-Reply-To: <CA+i5JwboSVnpFO6cvPP169gw-OXWVa5jQ34FXdk54t+L54h6Aw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox