From: Dan Winslow <d.winslow@cox.net>
To: pgsql-sql@postgresql.org
Subject: Diffcult query
Date: Fri, 21 Mar 2003 17:41:29 GMT
Message-ID: <d9Iea.117330$JE5.48428@news2.central.cox.net> (raw)
Hi folks. This is giving me fits. I feel like it oughta be simple, but
apparantly its not...I think.
Given a table :
create table tablea (
code1 varchar(32),
code2 varchar(32),
cost int
);
and the rows
code1 code2 cost
----------------------------------
"aaa" "bbb" 2
"ddd" "eee" 3
"bbb" "aaa" 6
"ggg" "hhh" 4
I need a ( preferably single ) query that will sum the costs for all unique
pairs of codes, without regard to column order. That is, for summing
purposes, rows 1 and 3 are identical, and should produce the sum of 8 for
the unordered pair("aaa","bbb"). It should also, of course, prevent the case
where ("bbb","aaa") is considered a seperate pair. Any ideas would be much
appreciated.
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: d.winslow@cox.net
Subject: Re: Diffcult query
In-Reply-To: <d9Iea.117330$JE5.48428@news2.central.cox.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