From: Andreas <maps.on@gmx.net>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Need help in grouping records
Date: Sat, 19 May 2012 21:04:38 +0200
Message-ID: <4FB7EEC6.1030004@gmx.net> (raw)
Hi,
I'm trying to fight against double entries in tables.
I got as far as I can find similar records with trigram string matching.
If I do this with a table compared to itself I get something like this:
id_a, id_b
3, 5
3, 7
5, 3
5, 7
7, 3
7, 5
11, 13
13, 11
so the records with the IDs 3, 5, 7 and 11, 13 are similar enough to
form a group.
How would I get a list of record-IDs with a group-ID like this
record_id, group_id
3, 1
5, 1
7, 1
11, 2
13, 2
Is there a way to get this by SQL ?
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: pgsql-sql@postgresql.org
Cc: maps.on@gmx.net
Subject: Re: Need help in grouping records
In-Reply-To: <4FB7EEC6.1030004@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox