From: Josh Berkus <josh@agliodbs.com>
To: Greg Spiegelberg <gspiegelberg@cranel.com>
To: PgSQL Performance ML <pgsql-performance@postgresql.org>
Subject: Re: Compare rows
Date: Wed, 8 Oct 2003 09:01:45 -0700
Message-ID: <200310080901.45093.josh@agliodbs.com> (raw)
In-Reply-To: <3F841A28.8060504@cranel.com>
References: <3F841A28.8060504@cranel.com>
Greg,
> Anyone have any suggestions on how to efficiently compare
> rows in the same table? This table has 637 columns to be
> compared and 642 total columns.
637 columns? Are you sure that's normalized? It's hard for me to conceive
of a circumstance where that many columns would be necessary.
If this isn't a catastrophic normalization problem (which it sounds like),
then you will probably still need to work through procedureal normalization
code, as SQL simply doesn't offer any way around naming all the columns by
hand. Perhaps you could describe the problem in more detail?
--
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-performance@postgresql.org
Cc: josh@agliodbs.com, gspiegelberg@cranel.com
Subject: Re: Compare rows
In-Reply-To: <200310080901.45093.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