pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Pavan Deolasee <pavan.deolasee@gmail.com>
To: Nacef LABIDI <nacef.l@gmail.com>
Cc: depesz@depesz.com, "Roland Voegtli" <voegtli@scnat.ch>
Cc: pgsql-sql@postgresql.org
Subject: Re: After updating dataset the record goes to the end of the dataset
Date: Tue, 22 Apr 2008 16:15:10 +0530
Message-ID: <2e78013d0804220345m50a89cf3i1906418adbb8d417@mail.gmail.com> (raw)
In-Reply-To: <f16f7ea00804220331u226df1ean9a17e12d9324e078@mail.gmail.com>
References: <f16f7ea00804220254i671e446au7c50dca45dea10d7@mail.gmail.com>
	<3B256469-4A00-44C3-8EB8-F49FA9F7259A@scnat.ch>
	<f16f7ea00804220310m26753072mec98ef0bc6bb2c9e@mail.gmail.com>
	<20080422101523.GB17162@depesz.com>
	<f16f7ea00804220331u226df1ean9a17e12d9324e078@mail.gmail.com>

On Tue, Apr 22, 2008 at 4:01 PM, Nacef LABIDI <nacef.l@gmail.com> 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



view thread (13+ messages)  latest in thread

Message-ID: <2e78013d0804220345m50a89cf3i1906418adbb8d417@mail.gmail.com>
Permalink:  ../2e78013d0804220345m50a89cf3i1906418adbb8d417@mail.gmail.com/
Also on:    postgresql.org/message-id/2e78013d0804220345m50a89cf3i1906418adbb8d417@mail.gmail.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: pavan.deolasee@gmail.com, nacef.l@gmail.com, voegtli@scnat.ch
  Subject: Re: After updating dataset the record goes to the end of the dataset
  In-Reply-To: <2e78013d0804220345m50a89cf3i1906418adbb8d417@mail.gmail.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