From: Kim Petersen <kp@kyborg.dk>
To: pgsql-sql@postgresql.org
Subject: problematic query (for me ;-)
Date: Wed, 05 Mar 2003 15:31:29 +0100
Message-ID: <3E660A41.7040509@kyborg.dk> (raw)
I'm trying to get a hint as to how i can solve this problem:
i have a table:
n | t
---+---
1 | 2
1 | 5
2 | 3
2 | 5
3 | 4
3 | 3
(6 rows)
now i want to find the pairs (n1,n2) where no t's collide - eg in this
table it would be (1,3) and (3,1).
Note - this is not homework ;-)
what i'm actually trying to do is to extract n=(countyid,roadid)
t=housenumber - and find out which roads that *cannot* cross county
border because their housenumbers collide (to this i've already narrowed
the n's depending on roadname).
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: kp@kyborg.dk
Subject: Re: problematic query (for me ;-)
In-Reply-To: <3E660A41.7040509@kyborg.dk>
* 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