Skip to content

Explain that SELECT results are unsorted #258

@warpech

Description

@warpech

As @miyconst writes in https://github.com/Starcounter/Blending/pull/320#discussion_r230687165:

The SQL SELECT result is never guaranteed to be in any specific order without ORDER BY

Can we please add information about this to the docs?


I understand that it is by SQL standard (and also seen in Oracle, SQLite, etc), but might be unexpected, compared to some other SQL implementations:

When you query data from a table, PostgreSQL returns the rows in the order that they were inserted into the table.

Source

Metadata

Metadata

Assignees

No one assigned

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions