pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dado Feigenblatt <dado@wildbrain.com>
To: Pgsql-Sql <pgsql-sql@postgresql.org>
To: josh berkus <josh@agliodbs.com>
Subject: Re: nextval on insert by arbitrary sequence
Date: Fri, 20 Jul 2001 17:04:47 -0700
Message-ID: <3B58C71F.9070703@wildbrain.com> (raw)
References: <web-88940@davinci.ethosmedia.com>
	<3B58C0C0.5000209@wildbrain.com>

Josh Berkus wrote:

> Dado,
>
> Maybe we're looking at this the hard way.  Have you thought of simply
> putting in a DATETIME column and sorting by that?
>
> -Josh
>
Sorting? I might have expressed myself wrong.
I'm not concerned about sorting.
I'm concerned about giving rows in a single table an unique, sequential 
numbered ID
based on a sequence per project (as in a serial counter, as in 'create 
sequence specific_project_sequence;')
e.g.
rows related to project A get a number from sequence A
rows related to project B get a number from sequence B

Is it clear now, or is it me who's not understanding what you're saying?

Sorry for the confusion.





-- 
Dado Feigenblatt                                 Wild Brain, Inc.   
Technical Director                               (415) 553-8000 x???
dado@wildbrain.com                               San Francisco, CA.







view thread (9+ messages)  latest in thread

Message-ID: <3B58C71F.9070703@wildbrain.com>
Permalink:  ../3B58C71F.9070703@wildbrain.com/
Also on:    postgresql.org/message-id/3B58C71F.9070703@wildbrain.com

 · 

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: dado@wildbrain.com, josh@agliodbs.com
  Subject: Re: nextval on insert by arbitrary sequence
  In-Reply-To: <3B58C71F.9070703@wildbrain.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