pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: data dependent sequences?
Date: Tue, 17 Jul 2007 16:48:44 -0400
Message-ID: <20070717204844.GE22634@phlogiston.dyndns.org> (raw)
In-Reply-To: <f7j1et$4s2$1@sea.gmane.org>
References: <AKEFJAHAPDBEDKIICNJKMEJPCDAA.smcg2297@frii.com>
	<1184515497.5778.141.camel@localhost.localdomain>
	<f7iggu$1nb$1@sea.gmane.org>
	<20070717150046.GC21688@phlogiston.dyndns.org>
	<f7int7$ue7$1@sea.gmane.org>
	<20070717164437.GJ21688@phlogiston.dyndns.org>
	<f7j1et$4s2$1@sea.gmane.org>

On Tue, Jul 17, 2007 at 12:23:21PM -0600, Stuart wrote:
> 
> Except that the value does matter outside of the database and thus
> needs to be remembered.  It is not used for ordering at all.

If you have two rows of data, where one column is data that varies as
a function of the data in some other column, then what you have is
data from two different tables, and not one table at all.  At least,
according to the rules of normalisation I know.

My best guess, however, is that you're trying to implement a poor
requirement.  My bet is that if you dig harder, you'll find out what
the requirement _really_ is, and then you won't have to implement
what sounds like a bad idea.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
However important originality may be in some fields, restraint and 
adherence to procedure emerge as the more significant virtues in a 
great many others.   --Alain de Botton



view thread (11+ messages)

Message-ID: <20070717204844.GE22634@phlogiston.dyndns.org>
Permalink:  ../20070717204844.GE22634@phlogiston.dyndns.org/
Also on:    postgresql.org/message-id/20070717204844.GE22634@phlogiston.dyndns.org

 · 

reply
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: ajs@crankycanuck.ca
  Subject: Re: data dependent sequences?
  In-Reply-To: <20070717204844.GE22634@phlogiston.dyndns.org>

* 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