Re: After updating dataset the record goes to the end of the dataset

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

-- 
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql