↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Versions

ORDER BY NULLS FIRST/LAST

Recorded source states and original language descriptions. Missing version evidence stays unknown.

The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.

No prose description is recorded; original links and version facts remain available.

SQL

Description

Selected version: PostgreSQL 18

No

20191817161514131211109.69.59.49.39.29.19.08.48.38.28.18.07.4
UnknownUnknownNoNoNoNoNoYesYesYesYesYesYesYesYesYesYesYesYesYesNoNoNoNo

Compare versions

Original documentation links

Complete source facts and provenance

legacy · center · 7bfc8dd35a44b1aedb12e647695bcfbcbe8efcaecbdaccd82d4069ade0ebc3b1

{
  "Key": "25",
  "SourceKind": "legacy",
  "SourceDatabase": "center",
  "SourceTable": "featurematrix_feature",
  "SourceKey": "25",
  "SourceHash": "7bfc8dd35a44b1aedb12e647695bcfbcbe8efcaecbdaccd82d4069ade0ebc3b1",
  "Name": "ORDER BY NULLS FIRST/LAST",
  "NameLocale": "en",
  "GroupKey": "15",
  "GroupName": "SQL",
  "GroupLocale": "en",
  "Ordinal": 0,
  "GroupOrder": 6,
  "Facts": {
    "featuredescription": "https://www.postgresql.org/docs/current/static/sql-select.html",
    "featurename": "ORDER BY NULLS FIRST/LAST",
    "group_id": 15,
    "id": 25,
    "v10": 1,
    "v11": 1,
    "v12": 1,
    "v13": 1,
    "v14": 0,
    "v15": 0,
    "v16": 0,
    "v17": 0,
    "v18": 0,
    "v74": 0,
    "v80": 0,
    "v81": 0,
    "v82": 0,
    "v83": 1,
    "v84": 1,
    "v90": 1,
    "v91": 1,
    "v92": 1,
    "v93": 1,
    "v94": 1,
    "v95": 1,
    "v96": 1
  },
  "Cells": [
    {
      "Version": "10",
      "State": "yes",
      "EvidenceKind": "legacy-database:v10",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "11",
      "State": "yes",
      "EvidenceKind": "legacy-database:v11",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "12",
      "State": "yes",
      "EvidenceKind": "legacy-database:v12",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "13",
      "State": "yes",
      "EvidenceKind": "legacy-database:v13",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "14",
      "State": "no",
      "EvidenceKind": "legacy-database:v14",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "15",
      "State": "no",
      "EvidenceKind": "legacy-database:v15",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "16",
      "State": "no",
      "EvidenceKind": "legacy-database:v16",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "17",
      "State": "no",
      "EvidenceKind": "legacy-database:v17",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "18",
      "State": "no",
      "EvidenceKind": "legacy-database:v18",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "7.4",
      "State": "no",
      "EvidenceKind": "legacy-database:v74",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.0",
      "State": "no",
      "EvidenceKind": "legacy-database:v80",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.1",
      "State": "no",
      "EvidenceKind": "legacy-database:v81",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.2",
      "State": "no",
      "EvidenceKind": "legacy-database:v82",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.3",
      "State": "yes",
      "EvidenceKind": "legacy-database:v83",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "8.4",
      "State": "yes",
      "EvidenceKind": "legacy-database:v84",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.0",
      "State": "yes",
      "EvidenceKind": "legacy-database:v90",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.1",
      "State": "yes",
      "EvidenceKind": "legacy-database:v91",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.2",
      "State": "yes",
      "EvidenceKind": "legacy-database:v92",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.3",
      "State": "yes",
      "EvidenceKind": "legacy-database:v93",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.4",
      "State": "yes",
      "EvidenceKind": "legacy-database:v94",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.5",
      "State": "yes",
      "EvidenceKind": "legacy-database:v95",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.6",
      "State": "yes",
      "EvidenceKind": "legacy-database:v96",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    }
  ],
  "Texts": [
    {
      "Locale": "en",
      "Title": "ORDER BY NULLS FIRST/LAST",
      "BodyHTML": "\u003cp\u003ehttps://www.postgresql.org/docs/current/static/sql-select.html\u003c/p\u003e\n",
      "SourceHash": "7bfc8dd35a44b1aedb12e647695bcfbcbe8efcaecbdaccd82d4069ade0ebc3b1",
      "ContentHash": "77575559548e09d19de8453fdc5c70c48252da89960525139a8fedeb9f5fb157",
      "Payload": {
        "description": "https://www.postgresql.org/docs/current/static/sql-select.html",
        "name": "ORDER BY NULLS FIRST/LAST"
      }
    }
  ],
  "GroupTitles": {
    "en": "SQL"
  }
}

Complete source data JSON