nodedb-sql 0.2.0

SQL parser, planner, and optimizer for NodeDB
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

// SPDX-License-Identifier: Apache-2.0

//! Miscellaneous scalar function registrations (coalesce, nullif, make_array, utility).

use nodedb_types::columnar::ColumnType;

use crate::functions::arg_types;
use crate::functions::registry::{FunctionCategory::Scalar, FunctionMeta};

use super::super::helpers::{m, no_trigger};

pub(super) fn misc_functions() -> Vec<FunctionMeta> {
    vec![
        m(
            "coalesce",
            Scalar,
            1,
            255,
            no_trigger(),
            None,
            arg_types::COALESCE_ARGS,
        ),
        m(
            "nullif",
            Scalar,
            2,
            2,
            no_trigger(),
            None,
            arg_types::NULLIF_ARGS,
        ),
        m(
            "make_array",
            Scalar,
            0,
            255,
            no_trigger(),
            Some(ColumnType::Array),
            arg_types::MAKE_ARRAY_ARGS,
        ),
        m(
            "ndb_chunk_text",
            Scalar,
            2,
            3,
            no_trigger(),
            Some(ColumnType::Array),
            arg_types::NDB_CHUNK_TEXT_ARGS,
        ),
    ]
}