Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 0428F2E0052 for ; Tue, 22 Apr 2008 07:45:15 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 77683-03 for ; Tue, 22 Apr 2008 07:45:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.28]) by developer.postgresql.org (Postfix) with ESMTP id C5AB12E0046 for ; Tue, 22 Apr 2008 07:45:11 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 2so1760030ywt.73 for ; Tue, 22 Apr 2008 03:45:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=Squt/HHIWj7go0rLi/YLqGNkPXX8lZpttgLsRNObLmw=; b=xzhEH/QSB7BWiB+QoxpH/fJ8F+IMNZlgGIwAQNmM4LbOwU3XAnp6vANHdLgM/gKo6LHyYFO0HvQ1A19MgAdWkSGGP1XcdE0WYWnlAgd0/1h/JotRNEMYhrYF8I2ptbFQsb8DFsyYqMmSBFElaPMPBm2xAN2T5jxqAEaCzYt4oHI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Ls/njyG+iyYv3C1e7AGYPGfa067dpXAfHqhyDdGi+GuwTr9wHKEEiZYZIF7ez7pUIH0o9ludnT2Pn4CmQmHa05J97fXWQioY41cMTDeRmFI7ZRFrdGESAGhh6AxH6y/KtYqm+GW1dYw5guPDV40u2JSUWV+UXIXJVPohJoAOxRY= Received: by 10.150.154.5 with SMTP id b5mr17248ybe.207.1208861110415; Tue, 22 Apr 2008 03:45:10 -0700 (PDT) Received: by 10.150.97.21 with HTTP; Tue, 22 Apr 2008 03:45:10 -0700 (PDT) Message-ID: <2e78013d0804220345m50a89cf3i1906418adbb8d417@mail.gmail.com> Date: Tue, 22 Apr 2008 16:15:10 +0530 From: "Pavan Deolasee" To: "Nacef LABIDI" Subject: Re: After updating dataset the record goes to the end of the dataset Cc: depesz@depesz.com, "Roland Voegtli" , pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <3B256469-4A00-44C3-8EB8-F49FA9F7259A@scnat.ch> <20080422101523.GB17162@depesz.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/134 X-Sequence-Number: 30673 On Tue, Apr 22, 2008 at 4:01 PM, Nacef LABIDI wrote: > > I am writing an application where here is some resources to plan events on. > I want to provide the user with the ability to customize the order in which > resources are displayed on the screen. To hope that the database would do that automatically for you is IMHO wrong. One way I can think of is to store the ordering information along with the user and then fetch the items in the desired order while displaying. Isn't that what you would anyway require if there are multiple users and each one wants to see the items in a different order ? Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com