| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Steve Clark <sclark(at)netwolves(dot)com> |
| Cc: | Chris Angelico <rosuav(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: noobie question |
| Date: | 2013-01-25 05:29:06 |
| Message-ID: | 20130125052906.GB30187@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jan 24, 2013 at 14:03:33 -0500,
Steve Clark <sclark(at)netwolves(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Uckun | 2013-01-25 08:53:01 | Re: Running update in chunks? |
| Previous Message | Bruno Wolff III | 2013-01-25 05:21:03 | Re: seeking SQL book recommendation |