Re: data dependent sequences?

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: data dependent sequences?
Date: 2007-07-17 15:00:46
Message-ID: 20070717150046.GC21688@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Jul 17, 2007 at 07:34:26AM -0600, Stuart wrote:
> I am not looking for gapless sequences. The reason I
> want to do this is the "typ" column is actually an indicator
> of the source of the rest of the infomation in the row.

Why do you need the sequence to be 1. . .n for each typ, then? If
they're just there to preserve order, one sequence will work just
fine. Otherwise, I think you have a normalisation problem.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
--Alexander Hamilton

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stuart 2007-07-17 15:40:21 Re: data dependent sequences?
Previous Message Richard Broersma Jr 2007-07-17 14:19:05 Re: data dependent sequences?