From: Josh Berkus <josh@agliodbs.com>
To: Fons Rave <fonzzz@xs4all.nl>
To: pgsql-sql@postgresql.org
Subject: Re: Records exactly the same.
Date: Fri, 20 Jul 2001 07:47:31 -0700
Message-ID: <web-88701@davinci.ethosmedia.com> (raw)
In-Reply-To: <9j4e1g$imb$1@news1.xs4all.nl>
Fons,
> I have a file in which there are records with what people have done.
> In the file
> are records with name, date, what they have done, time-length, etc.
> It is
> possible that there are two records that are exactly the same
> (somebody has done
> the same, on the same day for one hour). If I use a SELECT with GROUP
> on a list
> with some records that are exactly the same, only ONE of the
> identicals is
> shown. But I want to see them all.
Well, there isn't an easy answer for you ... because you've designed
your database wrong. Records should *never* be the same. That is, ni
fact, one of the cardinal rules of Relational Database Design.
You need to add an arbitrary primary key (e.g. act_key SERIAL NOT NULL
PRIMARY KEY) or some other piece of data (such as start_time) to make
each record unique. Then, by including that unique data in your query,
you can insure that all records are displayed.
Frankly, I'm surprise that you're not getting errors when you try to
DELETE a record. This usually happens in tables without a unique key.
It's been my argument for some time that PostgreSQL should require a
primary key on table creation.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. 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, fonzzz@xs4all.nl
Subject: Re: Records exactly the same.
In-Reply-To: <web-88701@davinci.ethosmedia.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