uqa-execution 0.6.0

Volcano physical operators with row-batch pipelines
Documentation
//
// Unified Query Algebra
//
// Copyright (c) 2023-2026 Cognica, Inc.
//

//! `PostgreSQL` identities of the implemented `substring` and `substr` overloads. The bit-string overloads are not implemented.

use super::BuiltinRoutineCatalogEntry;

/// `substring(text, text, text)` is the SQL-language function `RETURN substring($1, similar_to_escape($2, $3))`; this is the `pg_proc.prosqlbody` `PostgreSQL` 18 stores for it.
pub(super) const SIMILAR_SUBSTRING_SQL_BODY: &str = r"{QUERY :commandType 1 :querySource 0 :canSetTag true :utilityStmt <> :resultRelation 0 :hasAggs false :hasWindowFuncs false :hasTargetSRFs false :hasSubLinks false :hasDistinctOn false :hasRecursive false :hasModifyingCTE false :hasForUpdate false :hasRowSecurity false :hasGroupRTE false :isReturn true :cteList <> :rtable <> :rteperminfos <> :jointree {FROMEXPR :fromlist <> :quals <>} :mergeActionList <> :mergeTargetRelation 0 :mergeJoinCondition <> :targetList ({TARGETENTRY :expr {FUNCEXPR :funcid 2073 :funcresulttype 25 :funcretset false :funcvariadic false :funcformat 0 :funccollid 100 :inputcollid 100 :args ({PARAM :paramkind 0 :paramid 1 :paramtype 25 :paramtypmod -1 :paramcollid 100 :location -1} {FUNCEXPR :funcid 1986 :funcresulttype 25 :funcretset false :funcvariadic false :funcformat 0 :funccollid 100 :inputcollid 100 :args ({PARAM :paramkind 0 :paramid 2 :paramtype 25 :paramtypmod -1 :paramcollid 100 :location -1} {PARAM :paramkind 0 :paramid 3 :paramtype 25 :paramtypmod -1 :paramcollid 100 :location -1}) :location -1}) :location -1} :resno 1 :resname <> :ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk false}) :override 0 :onConflict <> :returningOldAlias <> :returningNewAlias <> :returningList <> :groupClause <> :groupDistinct false :groupingSets <> :havingQual <> :windowClause <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :limitOption 0 :rowMarks <> :setOperations <> :constraintDeps <> :withCheckOptions <> :stmt_location -1 :stmt_len -1}";

pub const ROUTINES: &[BuiltinRoutineCatalogEntry] = &[
    BuiltinRoutineCatalogEntry {
        oid: 877,
        name: "substr",
        kind: "f",
        strict: true,
        volatility: "i",
        parallel: "s",
        leakproof: false,
        return_type: 25,
        argument_types: &[25, 23, 23],
        argument_names: &[],
        default_arguments: 0,
        argument_defaults: None,
        source: "text_substr",
    },
    BuiltinRoutineCatalogEntry {
        oid: 883,
        name: "substr",
        kind: "f",
        strict: true,
        volatility: "i",
        parallel: "s",
        leakproof: false,
        return_type: 25,
        argument_types: &[25, 23],
        argument_names: &[],
        default_arguments: 0,
        argument_defaults: None,
        source: "text_substr_no_len",
    },
    BuiltinRoutineCatalogEntry {
        oid: 936,
        name: "substring",
        kind: "f",
        strict: true,
        volatility: "i",
        parallel: "s",
        leakproof: false,
        return_type: 25,
        argument_types: &[25, 23, 23],
        argument_names: &[],
        default_arguments: 0,
        argument_defaults: None,
        source: "text_substr",
    },
    BuiltinRoutineCatalogEntry {
        oid: 937,
        name: "substring",
        kind: "f",
        strict: true,
        volatility: "i",
        parallel: "s",
        leakproof: false,
        return_type: 25,
        argument_types: &[25, 23],
        argument_names: &[],
        default_arguments: 0,
        argument_defaults: None,
        source: "text_substr_no_len",
    },
    BuiltinRoutineCatalogEntry {
        oid: 2012,
        name: "substring",
        kind: "f",
        strict: true,
        volatility: "i",
        parallel: "s",
        leakproof: false,
        return_type: 17,
        argument_types: &[17, 23, 23],
        argument_names: &[],
        default_arguments: 0,
        argument_defaults: None,
        source: "bytea_substr",
    },
    BuiltinRoutineCatalogEntry {
        oid: 2013,
        name: "substring",
        kind: "f",
        strict: true,
        volatility: "i",
        parallel: "s",
        leakproof: false,
        return_type: 17,
        argument_types: &[17, 23],
        argument_names: &[],
        default_arguments: 0,
        argument_defaults: None,
        source: "bytea_substr_no_len",
    },
    BuiltinRoutineCatalogEntry {
        oid: 2073,
        name: "substring",
        kind: "f",
        strict: true,
        volatility: "i",
        parallel: "s",
        leakproof: false,
        return_type: 25,
        argument_types: &[25, 25],
        argument_names: &[],
        default_arguments: 0,
        argument_defaults: None,
        source: "textregexsubstr",
    },
    BuiltinRoutineCatalogEntry {
        oid: 2074,
        name: "substring",
        kind: "f",
        strict: true,
        volatility: "i",
        parallel: "s",
        leakproof: false,
        return_type: 25,
        argument_types: &[25, 25, 25],
        argument_names: &[],
        default_arguments: 0,
        argument_defaults: None,
        source: "",
    },
    BuiltinRoutineCatalogEntry {
        oid: 2085,
        name: "substr",
        kind: "f",
        strict: true,
        volatility: "i",
        parallel: "s",
        leakproof: false,
        return_type: 17,
        argument_types: &[17, 23, 23],
        argument_names: &[],
        default_arguments: 0,
        argument_defaults: None,
        source: "bytea_substr",
    },
    BuiltinRoutineCatalogEntry {
        oid: 2086,
        name: "substr",
        kind: "f",
        strict: true,
        volatility: "i",
        parallel: "s",
        leakproof: false,
        return_type: 17,
        argument_types: &[17, 23],
        argument_names: &[],
        default_arguments: 0,
        argument_defaults: None,
        source: "bytea_substr_no_len",
    },
];