# User-defined Order in SQL

DevFeed: [User-defined Order in SQL](<https://devfeed.tech/articles/user-defined-order-in-sql-21480.md>)

Original publisher: [Read original article](<https://begriffs.com/posts/2018-03-20-user-defined-order.html>)

Published: 2018-03-20T00:00:00Z

Content type: article

Language: en

Sources: [Joe Nelson](<https://devfeed.tech/sources/joe-nelson.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [To-Do](<https://devfeed.tech/topics/todo.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [applications](<https://devfeed.tech/tags/applications.md>), [article](<https://devfeed.tech/tags/article.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This article examines ways to model user-defined item order in SQL, including sequential integers, deferred uniqueness constraints, spaced position values, floating-point numbers, and precise numeric types. It considers how each approach handles inserting and reordering items, including update constraints and precision limits.

## Source excerpt

2018-03-20 Some applications, such as todo lists, need to maintain a user-defined order of items. The challenge is that the order is arbitrary and can change when the user rearranges items: This article investigates the best way to model the situation in SQL.