Re: noobie question

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: noobie question
Дата
Msg-id 20130125052906.GB30187@wolff.to
обсуждение исходный текст
Ответ на noobie question  (Steve Clark <sclark@netwolves.com>)
Список 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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: seeking SQL book recommendation
Следующее
От: Tim Uckun
Дата:
Сообщение: Re: Running update in chunks?