Received: from flip.wildbrain.com ([206.54.55.32]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6L06ha78782 for ; Fri, 20 Jul 2001 20:06:43 -0400 (EDT) (envelope-from dado@wildbrain.com) Received: from wildbrain.com (daedelus.wildbrain.com [192.168.1.38]) by flip.wildbrain.com (8.9.3/8.9.3) with ESMTP id QAA07488; Fri, 20 Jul 2001 16:04:33 -0700 Message-ID: <3B58C71F.9070703@wildbrain.com> Date: Fri, 20 Jul 2001 17:04:47 -0700 From: Dado Feigenblatt User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.2) Gecko/20010628 X-Accept-Language: en-us MIME-Version: 1.0 To: Pgsql-Sql , josh berkus Subject: Re: nextval on insert by arbitrary sequence References: <3B58C0C0.5000209@wildbrain.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200107/293 X-Sequence-Number: 4096 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.