↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Versions

Named parameters

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.

Procedural Languages

Description

allows the use of named parameters in pl/pgsql

Selected version: PostgreSQL 18

Yes

20191817161514131211109.69.59.49.39.29.19.08.48.38.28.18.07.4
UnknownUnknownYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesYesUnknownUnknown

Compare versions

Original documentation links

Recorded legacy identifiers: 83

Complete source facts and provenance

yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd

{
  "Key": "named-parameters",
  "SourceKind": "yaml",
  "SourceDatabase": "center",
  "SourceTable": "featurematrix.yaml",
  "SourceKey": "Named parameters",
  "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
  "Name": "Named parameters",
  "NameLocale": "en",
  "GroupKey": "procedural-languages",
  "GroupName": "Procedural Languages",
  "GroupLocale": "en",
  "Ordinal": 9,
  "GroupOrder": 19,
  "Facts": {
    "feature": {
      "description": "allows the use of named parameters in pl/pgsql",
      "name": "Named parameters",
      "versions": {
        "8.1": "Yes"
      }
    },
    "group": "Procedural Languages",
    "versions": {
      "max": 18,
      "min": 8.1
    }
  },
  "Cells": [
    {
      "Version": "10",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "11",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "12",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "13",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "14",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "15",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "16",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "17",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "18",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "8.1",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "8.2",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "8.3",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "8.4",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.0",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.1",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.2",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.3",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.4",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.5",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "9.6",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "8.1",
      "Supported": true,
      "Original": "Yes"
    }
  ],
  "Texts": [
    {
      "Locale": "en",
      "Title": "Named parameters",
      "BodyHTML": "\u003cp\u003eallows the use of named parameters in pl/pgsql\u003c/p\u003e\n",
      "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
      "ContentHash": "0c0dac4830a5776fa20bc5fac55cc53c8c301f2571738450468c3ab1d34a0eca",
      "Payload": {
        "description": "allows the use of named parameters in pl/pgsql",
        "name": "Named parameters",
        "versions": {
          "8.1": "Yes"
        }
      }
    },
    {
      "Locale": "zh-Hans",
      "Title": "命名参数",
      "BodyHTML": "\u003cp\u003e允许在 pl/pgsql 中使用命名参数\u003c/p\u003e\n",
      "SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
      "ContentHash": "18bae3e4fe07fd9ff1f6025230ce05dfd8f6e6bfce46a7359c6779b6cc820efb",
      "Payload": {
        "description": "允许在 pl/pgsql 中使用命名参数",
        "name": "命名参数"
      }
    }
  ],
  "GroupTitles": {
    "en": "Procedural Languages",
    "zh-Hans": "过程语言"
  },
  "LegacyIDs": [
    "83"
  ]
}

Complete source data JSON