Re: noobie question - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: noobie question
Date
Msg-id 20130125052906.GB30187@wolff.to
Whole thread Raw
In response to noobie question  (Steve Clark <sclark@netwolves.com>)
List pgsql-general
On Thu, Jan 24, 2013 at 14:03:33 -0500,
   Steve Clark <sclark@netwolves.com> wrote:
>
>It is really called rule_num and relates to "in what order firewall rules are applied". And it used
>to allow the user to place the firewall rules where they want them in relation to other rules.

If you just need ordering, you could choose to use a string or numeric to
give you ordering. That allows you to insert values in between existing
records without having to renumber.

When displaying the data the application can number them based on ordering.
And keep track of the current mapping between the number on the screen and
the key in the database.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: seeking SQL book recommendation
Next
From: Tim Uckun
Date:
Subject: Re: Running update in chunks?