uqa-execution 0.6.2

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

//! `PostgreSQL` identities of the regular-expression functions: `regexp_count`, `regexp_instr`, `regexp_like`, `regexp_match`, `regexp_matches`, `regexp_replace`, `regexp_split_to_array`, `regexp_split_to_table` and `regexp_substr`. Every overload is a strict, immutable, parallel-safe internal function without argument defaults.

use super::BuiltinRoutineCatalogEntry;

const TEXT: i64 = 25;
const INTEGER: i64 = 23;
const BOOLEAN: i64 = 16;
const TEXT_ARRAY: i64 = 1009;

const fn routine(
    oid: i64,
    name: &'static str,
    return_type: i64,
    argument_types: &'static [i64],
    argument_names: &'static [&'static str],
    source: &'static str,
) -> BuiltinRoutineCatalogEntry {
    BuiltinRoutineCatalogEntry {
        oid,
        name,
        kind: "f",
        strict: true,
        volatility: "i",
        parallel: "s",
        leakproof: false,
        return_type,
        argument_types,
        argument_names,
        default_arguments: 0,
        argument_defaults: None,
        source,
    }
}

pub const ROUTINES: &[BuiltinRoutineCatalogEntry] = &[
    routine(
        2284,
        "regexp_replace",
        TEXT,
        &[TEXT, TEXT, TEXT],
        &["string", "pattern", "replacement"],
        "textregexreplace_noopt",
    ),
    routine(
        2285,
        "regexp_replace",
        TEXT,
        &[TEXT, TEXT, TEXT, TEXT],
        &["string", "pattern", "replacement", "flags"],
        "textregexreplace",
    ),
    routine(
        2763,
        "regexp_matches",
        TEXT_ARRAY,
        &[TEXT, TEXT],
        &["string", "pattern"],
        "regexp_matches_no_flags",
    ),
    routine(
        2764,
        "regexp_matches",
        TEXT_ARRAY,
        &[TEXT, TEXT, TEXT],
        &["string", "pattern", "flags"],
        "regexp_matches",
    ),
    routine(
        2765,
        "regexp_split_to_table",
        TEXT,
        &[TEXT, TEXT],
        &["string", "pattern"],
        "regexp_split_to_table_no_flags",
    ),
    routine(
        2766,
        "regexp_split_to_table",
        TEXT,
        &[TEXT, TEXT, TEXT],
        &["string", "pattern", "flags"],
        "regexp_split_to_table",
    ),
    routine(
        2767,
        "regexp_split_to_array",
        TEXT_ARRAY,
        &[TEXT, TEXT],
        &["string", "pattern"],
        "regexp_split_to_array_no_flags",
    ),
    routine(
        2768,
        "regexp_split_to_array",
        TEXT_ARRAY,
        &[TEXT, TEXT, TEXT],
        &["string", "pattern", "flags"],
        "regexp_split_to_array",
    ),
    routine(
        3396,
        "regexp_match",
        TEXT_ARRAY,
        &[TEXT, TEXT],
        &["string", "pattern"],
        "regexp_match_no_flags",
    ),
    routine(
        3397,
        "regexp_match",
        TEXT_ARRAY,
        &[TEXT, TEXT, TEXT],
        &["string", "pattern", "flags"],
        "regexp_match",
    ),
    routine(
        6251,
        "regexp_replace",
        TEXT,
        &[TEXT, TEXT, TEXT, INTEGER, INTEGER, TEXT],
        &["string", "pattern", "replacement", "start", "N", "flags"],
        "textregexreplace_extended",
    ),
    routine(
        6252,
        "regexp_replace",
        TEXT,
        &[TEXT, TEXT, TEXT, INTEGER, INTEGER],
        &["string", "pattern", "replacement", "start", "N"],
        "textregexreplace_extended_no_flags",
    ),
    routine(
        6253,
        "regexp_replace",
        TEXT,
        &[TEXT, TEXT, TEXT, INTEGER],
        &["string", "pattern", "replacement", "start"],
        "textregexreplace_extended_no_n",
    ),
    routine(
        6254,
        "regexp_count",
        INTEGER,
        &[TEXT, TEXT],
        &["string", "pattern"],
        "regexp_count_no_start",
    ),
    routine(
        6255,
        "regexp_count",
        INTEGER,
        &[TEXT, TEXT, INTEGER],
        &["string", "pattern", "start"],
        "regexp_count_no_flags",
    ),
    routine(
        6256,
        "regexp_count",
        INTEGER,
        &[TEXT, TEXT, INTEGER, TEXT],
        &["string", "pattern", "start", "flags"],
        "regexp_count",
    ),
    routine(
        6257,
        "regexp_instr",
        INTEGER,
        &[TEXT, TEXT],
        &["string", "pattern"],
        "regexp_instr_no_start",
    ),
    routine(
        6258,
        "regexp_instr",
        INTEGER,
        &[TEXT, TEXT, INTEGER],
        &["string", "pattern", "start"],
        "regexp_instr_no_n",
    ),
    routine(
        6259,
        "regexp_instr",
        INTEGER,
        &[TEXT, TEXT, INTEGER, INTEGER],
        &["string", "pattern", "start", "N"],
        "regexp_instr_no_endoption",
    ),
    routine(
        6260,
        "regexp_instr",
        INTEGER,
        &[TEXT, TEXT, INTEGER, INTEGER, INTEGER],
        &["string", "pattern", "start", "N", "endoption"],
        "regexp_instr_no_flags",
    ),
    routine(
        6261,
        "regexp_instr",
        INTEGER,
        &[TEXT, TEXT, INTEGER, INTEGER, INTEGER, TEXT],
        &["string", "pattern", "start", "N", "endoption", "flags"],
        "regexp_instr_no_subexpr",
    ),
    routine(
        6262,
        "regexp_instr",
        INTEGER,
        &[TEXT, TEXT, INTEGER, INTEGER, INTEGER, TEXT, INTEGER],
        &[
            "string",
            "pattern",
            "start",
            "N",
            "endoption",
            "flags",
            "subexpr",
        ],
        "regexp_instr",
    ),
    routine(
        6263,
        "regexp_like",
        BOOLEAN,
        &[TEXT, TEXT],
        &["string", "pattern"],
        "regexp_like_no_flags",
    ),
    routine(
        6264,
        "regexp_like",
        BOOLEAN,
        &[TEXT, TEXT, TEXT],
        &["string", "pattern", "flags"],
        "regexp_like",
    ),
    routine(
        6265,
        "regexp_substr",
        TEXT,
        &[TEXT, TEXT],
        &["string", "pattern"],
        "regexp_substr_no_start",
    ),
    routine(
        6266,
        "regexp_substr",
        TEXT,
        &[TEXT, TEXT, INTEGER],
        &["string", "pattern", "start"],
        "regexp_substr_no_n",
    ),
    routine(
        6267,
        "regexp_substr",
        TEXT,
        &[TEXT, TEXT, INTEGER, INTEGER],
        &["string", "pattern", "start", "N"],
        "regexp_substr_no_flags",
    ),
    routine(
        6268,
        "regexp_substr",
        TEXT,
        &[TEXT, TEXT, INTEGER, INTEGER, TEXT],
        &["string", "pattern", "start", "N", "flags"],
        "regexp_substr_no_subexpr",
    ),
    routine(
        6269,
        "regexp_substr",
        TEXT,
        &[TEXT, TEXT, INTEGER, INTEGER, TEXT, INTEGER],
        &["string", "pattern", "start", "N", "flags", "subexpr"],
        "regexp_substr",
    ),
];