From: Josh Berkus <josh@agliodbs.com>
To: Dan Winslow <d.winslow@cox.net>
To: pgsql-sql@postgresql.org
Subject: Re: Diffcult query
Date: Fri, 21 Mar 2003 11:45:58 -0800
Message-ID: <200303211145.58768.josh@agliodbs.com> (raw)
In-Reply-To: <d9Iea.117330$JE5.48428@news2.central.cox.net>
References: <d9Iea.117330$JE5.48428@news2.central.cox.net>
Dan,
> Hi folks. This is giving me fits. I feel like it oughta be simple, but
> apparantly its not...I think.
> 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.
It's not simple, because your DB design is poorly normalized. My first
suggestion would be to make some design changes to your schema. Is that
possible?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
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: josh@agliodbs.com, d.winslow@cox.net
Subject: Re: Diffcult query
In-Reply-To: <200303211145.58768.josh@agliodbs.com>
* 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