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

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions