X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 11159D1EF5A for ; Sat, 8 May 2004 13:33:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 30056-04 for ; Sat, 8 May 2004 13:32:32 -0300 (ADT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id BD4E2D1EF2B for ; Sat, 8 May 2004 13:32:10 -0300 (ADT) Received: (qmail 7541 invoked by uid 500); 8 May 2004 16:36:41 -0000 Date: Sat, 8 May 2004 11:36:41 -0500 From: Bruno Wolff III To: Peter Galbavy Cc: pgsql-sql@postgresql.org Subject: Re: techniques for manual ordering of data ? Message-ID: <20040508163641.GA7519@wolff.to> Mail-Followup-To: Peter Galbavy , pgsql-sql@postgresql.org References: <007101c3ed67$cdab35f0$24e0a8c0@sonylaptop> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <007101c3ed67$cdab35f0$24e0a8c0@sonylaptop> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/81 X-Sequence-Number: 17795 On Sat, Feb 07, 2004 at 10:47:37 -0000, Peter Galbavy wrote: > > Here, a photograph may appear in multiple catalogue/collection places. What > I want to do is to allow the admin to reorder the display by using + / - > style buttons. My initial thought was to use an arbitrary "ordering" column, > like old BASIC line numbers, which would be initially allocated in 10s or > 100s, and then updating the value via the UI and occassionally applying a > "renum" style function when the list gets uneven. Numeric might be better for this than int, since you can keep subdividing without having to renumber. If you hide the real numbers from the users, you might not ever need to do a bulk renumber.