parse_expr.c File Reference

#include "postgres.h"
#include "catalog/pg_aggregate.h"
#include "catalog/pg_proc.h"
#include "catalog/pg_type.h"
#include "commands/dbcommands.h"
#include "miscadmin.h"
#include "nodes/makefuncs.h"
#include "nodes/nodeFuncs.h"
#include "optimizer/optimizer.h"
#include "parser/analyze.h"
#include "parser/parse_agg.h"
#include "parser/parse_clause.h"
#include "parser/parse_coerce.h"
#include "parser/parse_collate.h"
#include "parser/parse_expr.h"
#include "parser/parse_func.h"
#include "parser/parse_oper.h"
#include "parser/parse_relation.h"
#include "parser/parse_target.h"
#include "parser/parse_type.h"
#include "utils/builtins.h"
#include "utils/date.h"
#include "utils/fmgroids.h"
#include "utils/lsyscache.h"
#include "utils/timestamp.h"
#include "utils/xml.h"

Include dependency graph for parse_expr.c:

Go to the source code of this file.

Functions
static Node *	transformExprRecurse (ParseState *pstate, Node *expr)
static Node *	transformParamRef (ParseState *pstate, ParamRef *pref)
static Node *	transformAExprOp (ParseState *pstate, A_Expr *a)
static Node *	transformAExprOpAny (ParseState *pstate, A_Expr *a)
static Node *	transformAExprOpAll (ParseState *pstate, A_Expr *a)
static Node *	transformAExprDistinct (ParseState *pstate, A_Expr *a)
static Node *	transformAExprNullIf (ParseState *pstate, A_Expr *a)
static Node *	transformAExprIn (ParseState *pstate, A_Expr *a)
static Node *	transformAExprBetween (ParseState *pstate, A_Expr *a)
static Node *	transformBoolExpr (ParseState *pstate, BoolExpr *a)
static Node *	transformFuncCall (ParseState *pstate, FuncCall *fn)
static Node *	transformMultiAssignRef (ParseState *pstate, MultiAssignRef *maref)
static Node *	transformCaseExpr (ParseState *pstate, CaseExpr *c)
static Node *	transformSubLink (ParseState *pstate, SubLink *sublink)
static Node *	transformArrayExpr (ParseState *pstate, A_ArrayExpr *a, Oid array_type, Oid element_type, int32 typmod)
static Node *	transformRowExpr (ParseState *pstate, RowExpr *r, bool allowDefault)
static Node *	transformCoalesceExpr (ParseState *pstate, CoalesceExpr *c)
static Node *	transformMinMaxExpr (ParseState *pstate, MinMaxExpr *m)
static Node *	transformSQLValueFunction (ParseState *pstate, SQLValueFunction *svf)
static Node *	transformXmlExpr (ParseState *pstate, XmlExpr *x)
static Node *	transformXmlSerialize (ParseState *pstate, XmlSerialize *xs)
static Node *	transformBooleanTest (ParseState *pstate, BooleanTest *b)
static Node *	transformCurrentOfExpr (ParseState *pstate, CurrentOfExpr *cexpr)
static Node *	transformColumnRef (ParseState *pstate, ColumnRef *cref)
static Node *	transformWholeRowRef (ParseState *pstate, ParseNamespaceItem *nsitem, int sublevels_up, int location)
static Node *	transformIndirection (ParseState *pstate, A_Indirection *ind)
static Node *	transformTypeCast (ParseState *pstate, TypeCast *tc)
static Node *	transformCollateClause (ParseState *pstate, CollateClause *c)
static Node *	transformJsonObjectConstructor (ParseState *pstate, JsonObjectConstructor *ctor)
static Node *	transformJsonArrayConstructor (ParseState *pstate, JsonArrayConstructor *ctor)
static Node *	transformJsonArrayQueryConstructor (ParseState *pstate, JsonArrayQueryConstructor *ctor)
static Node *	transformJsonObjectAgg (ParseState *pstate, JsonObjectAgg *agg)
static Node *	transformJsonArrayAgg (ParseState *pstate, JsonArrayAgg *agg)
static Node *	transformJsonIsPredicate (ParseState *pstate, JsonIsPredicate *p)
static Node *	transformJsonFuncExpr (ParseState *pstate, JsonFuncExpr *p)
static Node *	transformJsonValueExpr (ParseState *pstate, JsonValueExpr *jve)
static Node *	transformJsonParseExpr (ParseState *pstate, JsonParseExpr *expr)
static Node *	transformJsonScalarExpr (ParseState *pstate, JsonScalarExpr *expr)
static Node *	transformJsonSerializeExpr (ParseState *pstate, JsonSerializeExpr *expr)
static Node *	make_row_comparison_op (ParseState *pstate, List *opname, List *largs, List *rargs, int location)
static Node *	make_row_distinct_op (ParseState *pstate, List *opname, RowExpr *lrow, RowExpr *rrow, int location)
static Expr *	make_distinct_op (ParseState *pstate, List *opname, Node *ltree, Node *rtree, int location)
static Node *	make_nulltest_from_distinct (ParseState *pstate, A_Expr *distincta, Node *arg)
Node *	transformExpr (ParseState *pstate, Node *expr, ParseExprKind exprKind)
static void	unknown_attribute (ParseState *pstate, Node *relref, const char *attname, int location)
static bool	exprIsNullConstant (Node *arg)
const char *	ParseExprKindName (ParseExprKind exprKind)
static Const *	getJsonEncodingConst (JsonFormat *format)
static Node *	makeJsonByteaToTextConversion (Node *expr, JsonFormat *format, int location)
static Node *	makeCaseTestExpr (Node *expr)
static Node *	transformJsonValueExprExt (ParseState *pstate, JsonValueExpr *ve, JsonFormatType default_format, bool isarg, Oid targettype)
static Node *	transformJsonValueExprDefault (ParseState *pstate, JsonValueExpr *jve)
static void	checkJsonOutputFormat (ParseState *pstate, const JsonFormat *format, Oid targettype, bool allow_format_for_non_strings)
static JsonReturning *	transformJsonOutput (ParseState *pstate, const JsonOutput *output, bool allow_format)
static JsonReturning *	transformJsonConstructorOutput (ParseState *pstate, JsonOutput *output, List *args)
static Node *	coerceJsonFuncExpr (ParseState *pstate, Node *expr, const JsonReturning *returning, bool report_error)
static Node *	makeJsonConstructorExpr (ParseState *pstate, JsonConstructorType type, List *args, Expr *fexpr, JsonReturning *returning, bool unique, bool absent_on_null, int location)
static Node *	transformJsonAggConstructor (ParseState *pstate, JsonAggConstructor *agg_ctor, JsonReturning *returning, List *args, const char *aggfn, Oid aggtype, JsonConstructorType ctor_type, bool unique, bool absent_on_null)
static Node *	transformJsonParseArg (ParseState *pstate, Node *jsexpr, JsonFormat *format, Oid *exprtype)
static void	transformJsonPassingArgs (ParseState *pstate, JsonFormatType format, List *args, List **passing_values, List **passing_names)
static JsonBehavior *	transformJsonBehavior (ParseState *pstate, JsonBehavior *behavior, JsonBehaviorType default_behavior)
static JsonExpr *	transformJsonExprCommon (ParseState *pstate, JsonFuncExpr *func)
static void	assignDefaultJsonReturningType (Node *context_item, JsonFormat *context_format, JsonReturning *ret)
static JsonCoercion *	coerceJsonExpr (ParseState *pstate, Node *expr, const JsonReturning *returning)
static void	transformJsonFuncExprOutput (ParseState *pstate, JsonFuncExpr *func, JsonExpr *jsexpr)
static Node *	coerceDefaultJsonExpr (ParseState *pstate, JsonExpr *jsexpr, Node *defexpr)
static JsonCoercion *	initJsonItemCoercion (ParseState *pstate, Oid typid, const JsonReturning *returning)
static void	initJsonItemCoercions (ParseState *pstate, JsonItemCoercions *coercions, const JsonReturning *returning, Oid contextItemTypeId)
static JsonReturning *	transformJsonConstructorRet (ParseState *pstate, JsonOutput *output, const char *fname)

Variables
bool	Transform_null_equals = false

Function Documentation

assignDefaultJsonReturningType()

static void assignDefaultJsonReturningType ( Node *  context_item, JsonFormat *  context_format, JsonReturning *  ret  )

static

Definition at line 4157 of file parse_expr.c.

{
    bool        is_jsonb;
 
    ret->format = copyObject(context_format);
 
    if (ret->format->format_type == JS_FORMAT_DEFAULT)
        is_jsonb = exprType(context_item) == JSONBOID;
    else
        is_jsonb = ret->format->format_type == JS_FORMAT_JSONB;
 
    ret->typid = is_jsonb ? JSONBOID : JSONOID;
    ret->typmod = -1;
}

References copyObject, exprType(), JsonReturning::format, JsonFormat::format_type, JS_FORMAT_DEFAULT, JS_FORMAT_JSONB, JsonReturning::typid, and JsonReturning::typmod.

Referenced by transformJsonFuncExprOutput().

checkJsonOutputFormat()

static void checkJsonOutputFormat ( ParseState *  pstate, const JsonFormat *  format, Oid  targettype, bool  allow_format_for_non_strings  )

static

Definition at line 3423 of file parse_expr.c.

{
    if (!allow_format_for_non_strings &&
        format->format_type != JS_FORMAT_DEFAULT &&
        (targettype != BYTEAOID &&
         targettype != JSONOID &&
         targettype != JSONBOID))
    {
        char        typcategory;
        bool        typispreferred;
 
        get_type_category_preferred(targettype, &typcategory, &typispreferred);
 
        if (typcategory != TYPCATEGORY_STRING)
            ereport(ERROR,
                    (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                     parser_errposition(pstate, format->location),
                     errmsg("cannot use JSON format with non-string output types")));
    }
 
    if (format->format_type == JS_FORMAT_JSON)
    {
        JsonEncoding enc = format->encoding != JS_ENC_DEFAULT ?
        format->encoding : JS_ENC_UTF8;
 
        if (targettype != BYTEAOID &&
            format->encoding != JS_ENC_DEFAULT)
            ereport(ERROR,
                    (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                     parser_errposition(pstate, format->location),
                     errmsg("cannot set JSON encoding for non-bytea output types")));
 
        if (enc != JS_ENC_UTF8)
            ereport(ERROR,
                    (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                     errmsg("unsupported JSON encoding"),
                     errhint("only UTF8 JSON encoding is supported"),
                     parser_errposition(pstate, format->location)));
    }
}

References enc, ereport, errcode(), errhint(), errmsg(), ERROR, format, get_type_category_preferred(), JS_ENC_DEFAULT, JS_ENC_UTF8, JS_FORMAT_DEFAULT, JS_FORMAT_JSON, and parser_errposition().

Referenced by transformJsonOutput().

coerceDefaultJsonExpr()

static Node* coerceDefaultJsonExpr ( ParseState *  pstate, JsonExpr *  jsexpr, Node *  defexpr  )

static

Definition at line 4263 of file parse_expr.c.

{
    int         location;
    Oid         exprtype;
 
    if (!defexpr)
        return NULL;
 
    exprtype = exprType(defexpr);
    location = exprLocation(defexpr);
 
    if (location < 0)
        location = jsexpr->location;
 
    defexpr = coerce_to_target_type(pstate,
                                    defexpr,
                                    exprtype,
                                    jsexpr->returning->typid,
                                    jsexpr->returning->typmod,
                                    COERCION_EXPLICIT,
                                    COERCE_IMPLICIT_CAST,
                                    location);
 
    if (!defexpr)
        ereport(ERROR,
                (errcode(ERRCODE_CANNOT_COERCE),
                 errmsg("cannot cast DEFAULT expression type %s to %s",
                        format_type_be(exprtype),
                        format_type_be(jsexpr->returning->typid)),
                 parser_errposition(pstate, location)));
 
    return defexpr;
}

References COERCE_IMPLICIT_CAST, coerce_to_target_type(), COERCION_EXPLICIT, ereport, errcode(), errmsg(), ERROR, exprLocation(), exprType(), format_type_be(), JsonExpr::location, parser_errposition(), JsonExpr::returning, JsonReturning::typid, and JsonReturning::typmod.

Referenced by transformJsonFuncExpr().

coerceJsonExpr()

static JsonCoercion* coerceJsonExpr ( ParseState *  pstate, Node *  expr, const JsonReturning *  returning  )

static

Definition at line 4179 of file parse_expr.c.

{
    char        typtype;
    JsonCoercion *coercion = makeNode(JsonCoercion);
 
    coercion->expr = coerceJsonFuncExpr(pstate, expr, returning, false);
 
    if (coercion->expr)
    {
        if (coercion->expr == expr)
            coercion->expr = NULL;
 
        return coercion;
    }
 
    typtype = get_typtype(returning->typid);
 
    if (returning->typid == RECORDOID ||
        typtype == TYPTYPE_COMPOSITE ||
        typtype == TYPTYPE_DOMAIN ||
        type_is_array(returning->typid))
        coercion->via_populate = true;
    else
        coercion->via_io = true;
 
    return coercion;
}

References coerceJsonFuncExpr(), JsonCoercion::expr, get_typtype(), makeNode, type_is_array, JsonReturning::typid, JsonCoercion::via_io, and JsonCoercion::via_populate.

Referenced by initJsonItemCoercion(), and transformJsonFuncExprOutput().

coerceJsonFuncExpr()

static Node* coerceJsonFuncExpr ( ParseState *  pstate, Node *  expr, const JsonReturning *  returning, bool  report_error  )

static

Definition at line 3558 of file parse_expr.c.

{
    Node       *res;
    int         location;
    Oid         exprtype = exprType(expr);
 
    /* if output type is not specified or equals to function type, return */
    if (!OidIsValid(returning->typid) || returning->typid == exprtype)
        return expr;
 
    location = exprLocation(expr);
 
    if (location < 0)
        location = returning->format->location;
 
    /* special case for RETURNING bytea FORMAT json */
    if (returning->format->format_type == JS_FORMAT_JSON &&
        returning->typid == BYTEAOID)
    {
        /* encode json text into bytea using pg_convert_to() */
        Node       *texpr = coerce_to_specific_type(pstate, expr, TEXTOID,
                                                    "JSON_FUNCTION");
        Const      *enc = getJsonEncodingConst(returning->format);
        FuncExpr   *fexpr = makeFuncExpr(F_CONVERT_TO, BYTEAOID,
                                         list_make2(texpr, enc),
                                         InvalidOid, InvalidOid,
                                         COERCE_EXPLICIT_CALL);
 
        fexpr->location = location;
 
        return (Node *) fexpr;
    }
 
    /* try to coerce expression to the output type */
    res = coerce_to_target_type(pstate, expr, exprtype,
                                returning->typid, returning->typmod,
    /* XXX throwing errors when casting to char(N) */
                                COERCION_EXPLICIT,
                                COERCE_EXPLICIT_CAST,
                                location);
 
    if (!res && report_error)
        ereport(ERROR,
                (errcode(ERRCODE_CANNOT_COERCE),
                 errmsg("cannot cast type %s to %s",
                        format_type_be(exprtype),
                        format_type_be(returning->typid)),
                 parser_coercion_errposition(pstate, location, expr)));
 
    return res;
}

References COERCE_EXPLICIT_CALL, COERCE_EXPLICIT_CAST, coerce_to_specific_type(), coerce_to_target_type(), COERCION_EXPLICIT, enc, ereport, errcode(), errmsg(), ERROR, exprLocation(), exprType(), JsonReturning::format, JsonFormat::format_type, format_type_be(), getJsonEncodingConst(), InvalidOid, JS_FORMAT_JSON, list_make2, FuncExpr::location, JsonFormat::location, makeFuncExpr(), OidIsValid, parser_coercion_errposition(), res, JsonReturning::typid, and JsonReturning::typmod.

Referenced by coerceJsonExpr(), and makeJsonConstructorExpr().

exprIsNullConstant()

static bool exprIsNullConstant ( Node *  arg )

static

Definition at line 910 of file parse_expr.c.

{
    if (arg && IsA(arg, A_Const))
    {
        A_Const    *con = (A_Const *) arg;
 
        if (con->isnull)
            return true;
    }
    return false;
}

References arg, IsA, and A_Const::isnull.

Referenced by transformAExprDistinct(), and transformAExprOp().

getJsonEncodingConst()

static Const* getJsonEncodingConst ( JsonFormat *  format )

static

Definition at line 3175 of file parse_expr.c.

{
    JsonEncoding encoding;
    const char *enc;
    Name        encname = palloc(sizeof(NameData));
 
    if (!format ||
        format->format_type == JS_FORMAT_DEFAULT ||
        format->encoding == JS_ENC_DEFAULT)
        encoding = JS_ENC_UTF8;
    else
        encoding = format->encoding;
 
    switch (encoding)
    {
        case JS_ENC_UTF16:
            enc = "UTF16";
            break;
        case JS_ENC_UTF32:
            enc = "UTF32";
            break;
        case JS_ENC_UTF8:
            enc = "UTF8";
            break;
        default:
            elog(ERROR, "invalid JSON encoding: %d", encoding);
            break;
    }
 
    namestrcpy(encname, enc);
 
    return makeConst(NAMEOID, -1, InvalidOid, NAMEDATALEN,
                     NameGetDatum(encname), false, false);
}

References elog, enc, encoding, ERROR, format, InvalidOid, JS_ENC_DEFAULT, JS_ENC_UTF16, JS_ENC_UTF32, JS_ENC_UTF8, JS_FORMAT_DEFAULT, makeConst(), NAMEDATALEN, NameGetDatum, namestrcpy(), and palloc().

Referenced by coerceJsonFuncExpr(), and makeJsonByteaToTextConversion().

initJsonItemCoercion()

static JsonCoercion* initJsonItemCoercion ( ParseState *  pstate, Oid  typid, const JsonReturning *  returning  )

static

Definition at line 4302 of file parse_expr.c.

{
    Node       *expr;
 
    if (typid == UNKNOWNOID)
    {
        expr = (Node *) makeNullConst(UNKNOWNOID, -1, InvalidOid);
    }
    else
    {
        CaseTestExpr *placeholder = makeNode(CaseTestExpr);
 
        placeholder->typeId = typid;
        placeholder->typeMod = -1;
        placeholder->collation = InvalidOid;
 
        expr = (Node *) placeholder;
    }
 
    return coerceJsonExpr(pstate, expr, returning);
}

References coerceJsonExpr(), CaseTestExpr::collation, InvalidOid, makeNode, makeNullConst(), CaseTestExpr::typeId, and CaseTestExpr::typeMod.

Referenced by initJsonItemCoercions().

initJsonItemCoercions()

static void initJsonItemCoercions ( ParseState *  pstate, JsonItemCoercions *  coercions, const JsonReturning *  returning, Oid  contextItemTypeId  )

static

Definition at line 4326 of file parse_expr.c.

{
    struct
    {
        JsonCoercion **coercion;
        Oid         typid;
    }          *p,
                coercionTypids[] =
    {
        {&coercions->null, UNKNOWNOID},
        {&coercions->string, TEXTOID},
        {&coercions->numeric, NUMERICOID},
        {&coercions->boolean, BOOLOID},
        {&coercions->date, DATEOID},
        {&coercions->time, TIMEOID},
        {&coercions->timetz, TIMETZOID},
        {&coercions->timestamp, TIMESTAMPOID},
        {&coercions->timestamptz, TIMESTAMPTZOID},
        {&coercions->composite, contextItemTypeId},
        {NULL, InvalidOid}
    };
 
    for (p = coercionTypids; p->coercion; p++)
        *p->coercion = initJsonItemCoercion(pstate, p->typid, returning);
}

References JsonItemCoercions::boolean, JsonItemCoercions::composite, JsonItemCoercions::date, initJsonItemCoercion(), InvalidOid, JsonItemCoercions::null, JsonItemCoercions::numeric, JsonItemCoercions::string, JsonItemCoercions::time, JsonItemCoercions::timestamp, JsonItemCoercions::timestamptz, and JsonItemCoercions::timetz.

Referenced by transformJsonFuncExpr().

make_distinct_op()

static Expr * make_distinct_op ( ParseState *  pstate, List *  opname, Node *  ltree, Node *  rtree, int  location  )

static

Definition at line 3013 of file parse_expr.c.

{
    Expr       *result;
 
    result = make_op(pstate, opname, ltree, rtree,
                     pstate->p_last_srf, location);
    if (((OpExpr *) result)->opresulttype != BOOLOID)
        ereport(ERROR,
                (errcode(ERRCODE_DATATYPE_MISMATCH),
                 errmsg("IS DISTINCT FROM requires = operator to yield boolean"),
                 parser_errposition(pstate, location)));
    if (((OpExpr *) result)->opretset)
        ereport(ERROR,
                (errcode(ERRCODE_DATATYPE_MISMATCH),
        /* translator: %s is name of a SQL construct, eg NULLIF */
                 errmsg("%s must not return a set", "IS DISTINCT FROM"),
                 parser_errposition(pstate, location)));
 
    /*
     * We rely on DistinctExpr and OpExpr being same struct
     */
    NodeSetTag(result, T_DistinctExpr);
 
    return result;
}

References ereport, errcode(), errmsg(), ERROR, make_op(), NodeSetTag, ParseState::p_last_srf, parser_errposition(), and T_DistinctExpr.

Referenced by make_row_distinct_op(), and transformAExprDistinct().

make_nulltest_from_distinct()

static Node * make_nulltest_from_distinct ( ParseState *  pstate, A_Expr *  distincta, Node *  arg  )

static

Definition at line 3046 of file parse_expr.c.

{
    NullTest   *nt = makeNode(NullTest);
 
    nt->arg = (Expr *) transformExprRecurse(pstate, arg);
    /* the argument can be any type, so don't coerce it */
    if (distincta->kind == AEXPR_NOT_DISTINCT)
        nt->nulltesttype = IS_NULL;
    else
        nt->nulltesttype = IS_NOT_NULL;
    /* argisrow = false is correct whether or not arg is composite */
    nt->argisrow = false;
    nt->location = distincta->location;
    return (Node *) nt;
}

References AEXPR_NOT_DISTINCT, arg, NullTest::arg, NullTest::argisrow, IS_NOT_NULL, IS_NULL, A_Expr::kind, A_Expr::location, NullTest::location, makeNode, NullTest::nulltesttype, and transformExprRecurse().

Referenced by transformAExprDistinct().

make_row_comparison_op()

static Node * make_row_comparison_op ( ParseState *  pstate, List *  opname, List *  largs, List *  rargs, int  location  )

static

Definition at line 2767 of file parse_expr.c.

{
    RowCompareExpr *rcexpr;
    RowCompareType rctype;
    List       *opexprs;
    List       *opnos;
    List       *opfamilies;
    ListCell   *l,
               *r;
    List      **opinfo_lists;
    Bitmapset  *strats;
    int         nopers;
    int         i;
 
    nopers = list_length(largs);
    if (nopers != list_length(rargs))
        ereport(ERROR,
                (errcode(ERRCODE_SYNTAX_ERROR),
                 errmsg("unequal number of entries in row expressions"),
                 parser_errposition(pstate, location)));
 
    /*
     * We can't compare zero-length rows because there is no principled basis
     * for figuring out what the operator is.
     */
    if (nopers == 0)
        ereport(ERROR,
                (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                 errmsg("cannot compare rows of zero length"),
                 parser_errposition(pstate, location)));
 
    /*
     * Identify all the pairwise operators, using make_op so that behavior is
     * the same as in the simple scalar case.
     */
    opexprs = NIL;
    forboth(l, largs, r, rargs)
    {
        Node       *larg = (Node *) lfirst(l);
        Node       *rarg = (Node *) lfirst(r);
        OpExpr     *cmp;
 
        cmp = castNode(OpExpr, make_op(pstate, opname, larg, rarg,
                                       pstate->p_last_srf, location));
 
        /*
         * We don't use coerce_to_boolean here because we insist on the
         * operator yielding boolean directly, not via coercion.  If it
         * doesn't yield bool it won't be in any index opfamilies...
         */
        if (cmp->opresulttype != BOOLOID)
            ereport(ERROR,
                    (errcode(ERRCODE_DATATYPE_MISMATCH),
                     errmsg("row comparison operator must yield type boolean, "
                            "not type %s",
                            format_type_be(cmp->opresulttype)),
                     parser_errposition(pstate, location)));
        if (expression_returns_set((Node *) cmp))
            ereport(ERROR,
                    (errcode(ERRCODE_DATATYPE_MISMATCH),
                     errmsg("row comparison operator must not return a set"),
                     parser_errposition(pstate, location)));
        opexprs = lappend(opexprs, cmp);
    }
 
    /*
     * If rows are length 1, just return the single operator.  In this case we
     * don't insist on identifying btree semantics for the operator (but we
     * still require it to return boolean).
     */
    if (nopers == 1)
        return (Node *) linitial(opexprs);
 
    /*
     * Now we must determine which row comparison semantics (= <> < <= > >=)
     * apply to this set of operators.  We look for btree opfamilies
     * containing the operators, and see which interpretations (strategy
     * numbers) exist for each operator.
     */
    opinfo_lists = (List **) palloc(nopers * sizeof(List *));
    strats = NULL;
    i = 0;
    foreach(l, opexprs)
    {
        Oid         opno = ((OpExpr *) lfirst(l))->opno;
        Bitmapset  *this_strats;
        ListCell   *j;
 
        opinfo_lists[i] = get_op_btree_interpretation(opno);
 
        /*
         * convert strategy numbers into a Bitmapset to make the intersection
         * calculation easy.
         */
        this_strats = NULL;
        foreach(j, opinfo_lists[i])
        {
            OpBtreeInterpretation *opinfo = lfirst(j);
 
            this_strats = bms_add_member(this_strats, opinfo->strategy);
        }
        if (i == 0)
            strats = this_strats;
        else
            strats = bms_int_members(strats, this_strats);
        i++;
    }
 
    /*
     * If there are multiple common interpretations, we may use any one of
     * them ... this coding arbitrarily picks the lowest btree strategy
     * number.
     */
    i = bms_first_member(strats);
    if (i < 0)
    {
        /* No common interpretation, so fail */
        ereport(ERROR,
                (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                 errmsg("could not determine interpretation of row comparison operator %s",
                        strVal(llast(opname))),
                 errhint("Row comparison operators must be associated with btree operator families."),
                 parser_errposition(pstate, location)));
    }
    rctype = (RowCompareType) i;
 
    /*
     * For = and <> cases, we just combine the pairwise operators with AND or
     * OR respectively.
     */
    if (rctype == ROWCOMPARE_EQ)
        return (Node *) makeBoolExpr(AND_EXPR, opexprs, location);
    if (rctype == ROWCOMPARE_NE)
        return (Node *) makeBoolExpr(OR_EXPR, opexprs, location);
 
    /*
     * Otherwise we need to choose exactly which opfamily to associate with
     * each operator.
     */
    opfamilies = NIL;
    for (i = 0; i < nopers; i++)
    {
        Oid         opfamily = InvalidOid;
        ListCell   *j;
 
        foreach(j, opinfo_lists[i])
        {
            OpBtreeInterpretation *opinfo = lfirst(j);
 
            if (opinfo->strategy == rctype)
            {
                opfamily = opinfo->opfamily_id;
                break;
            }
        }
        if (OidIsValid(opfamily))
            opfamilies = lappend_oid(opfamilies, opfamily);
        else                    /* should not happen */
            ereport(ERROR,
                    (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                     errmsg("could not determine interpretation of row comparison operator %s",
                            strVal(llast(opname))),
                     errdetail("There are multiple equally-plausible candidates."),
                     parser_errposition(pstate, location)));
    }
 
    /*
     * Now deconstruct the OpExprs and create a RowCompareExpr.
     *
     * Note: can't just reuse the passed largs/rargs lists, because of
     * possibility that make_op inserted coercion operations.
     */
    opnos = NIL;
    largs = NIL;
    rargs = NIL;
    foreach(l, opexprs)
    {
        OpExpr     *cmp = (OpExpr *) lfirst(l);
 
        opnos = lappend_oid(opnos, cmp->opno);
        largs = lappend(largs, linitial(cmp->args));
        rargs = lappend(rargs, lsecond(cmp->args));
    }
 
    rcexpr = makeNode(RowCompareExpr);
    rcexpr->rctype = rctype;
    rcexpr->opnos = opnos;
    rcexpr->opfamilies = opfamilies;
    rcexpr->inputcollids = NIL; /* assign_expr_collations will fix this */
    rcexpr->largs = largs;
    rcexpr->rargs = rargs;
 
    return (Node *) rcexpr;
}

References AND_EXPR, bms_add_member(), bms_first_member(), bms_int_members(), castNode, cmp(), ereport, errcode(), errdetail(), errhint(), errmsg(), ERROR, expression_returns_set(), forboth, format_type_be(), get_op_btree_interpretation(), i, RowCompareExpr::inputcollids, InvalidOid, j, lappend(), lappend_oid(), RowCompareExpr::largs, lfirst, linitial, list_length(), llast, lsecond, make_op(), makeBoolExpr(), makeNode, NIL, OidIsValid, RowCompareExpr::opfamilies, OpBtreeInterpretation::opfamily_id, RowCompareExpr::opnos, OR_EXPR, ParseState::p_last_srf, palloc(), parser_errposition(), RowCompareExpr::rargs, RowCompareExpr::rctype, ROWCOMPARE_EQ, ROWCOMPARE_NE, OpBtreeInterpretation::strategy, and strVal.

Referenced by transformAExprIn(), transformAExprOp(), and transformSubLink().

make_row_distinct_op()

static Node * make_row_distinct_op ( ParseState *  pstate, List *  opname, RowExpr *  lrow, RowExpr *  rrow, int  location  )

static

Definition at line 2969 of file parse_expr.c.

{
    Node       *result = NULL;
    List       *largs = lrow->args;
    List       *rargs = rrow->args;
    ListCell   *l,
               *r;
 
    if (list_length(largs) != list_length(rargs))
        ereport(ERROR,
                (errcode(ERRCODE_SYNTAX_ERROR),
                 errmsg("unequal number of entries in row expressions"),
                 parser_errposition(pstate, location)));
 
    forboth(l, largs, r, rargs)
    {
        Node       *larg = (Node *) lfirst(l);
        Node       *rarg = (Node *) lfirst(r);
        Node       *cmp;
 
        cmp = (Node *) make_distinct_op(pstate, opname, larg, rarg, location);
        if (result == NULL)
            result = cmp;
        else
            result = (Node *) makeBoolExpr(OR_EXPR,
                                           list_make2(result, cmp),
                                           location);
    }
 
    if (result == NULL)
    {
        /* zero-length rows?  Generate constant FALSE */
        result = makeBoolConst(false, false);
    }
 
    return result;
}

References RowExpr::args, cmp(), ereport, errcode(), errmsg(), ERROR, forboth, lfirst, list_length(), list_make2, make_distinct_op(), makeBoolConst(), makeBoolExpr(), OR_EXPR, and parser_errposition().

Referenced by transformAExprDistinct().

makeCaseTestExpr()

static Node* makeCaseTestExpr ( Node *  expr )

static

Definition at line 3231 of file parse_expr.c.

{
    CaseTestExpr *placeholder = makeNode(CaseTestExpr);
 
    placeholder->typeId = exprType(expr);
    placeholder->typeMod = exprTypmod(expr);
    placeholder->collation = exprCollation(expr);
 
    return (Node *) placeholder;
}

References CaseTestExpr::collation, exprCollation(), exprType(), exprTypmod(), makeNode, CaseTestExpr::typeId, and CaseTestExpr::typeMod.

Referenced by makeJsonConstructorExpr(), transformJsonFuncExprOutput(), transformJsonParseArg(), and transformJsonValueExprExt().

makeJsonByteaToTextConversion()

static Node* makeJsonByteaToTextConversion ( Node *  expr, JsonFormat *  format, int  location  )

static

Definition at line 3214 of file parse_expr.c.

{
    Const      *encoding = getJsonEncodingConst(format);
    FuncExpr   *fexpr = makeFuncExpr(F_CONVERT_FROM, TEXTOID,
                                     list_make2(expr, encoding),
                                     InvalidOid, InvalidOid,
                                     COERCE_EXPLICIT_CALL);
 
    fexpr->location = location;
 
    return (Node *) fexpr;
}

References COERCE_EXPLICIT_CALL, encoding, format, getJsonEncodingConst(), InvalidOid, list_make2, FuncExpr::location, and makeFuncExpr().

Referenced by transformJsonParseArg(), and transformJsonValueExprExt().

makeJsonConstructorExpr()

static Node* makeJsonConstructorExpr ( ParseState *  pstate, JsonConstructorType  type, List *  args, Expr *  fexpr, JsonReturning *  returning, bool  unique, bool  absent_on_null, int  location  )

static

Definition at line 3612 of file parse_expr.c.

{
    JsonConstructorExpr *jsctor = makeNode(JsonConstructorExpr);
    Node       *placeholder;
    Node       *coercion;
    Oid         intermediate_typid =
    returning->format->format_type == JS_FORMAT_JSONB ? JSONBOID : JSONOID;
 
    jsctor->args = args;
    jsctor->func = fexpr;
    jsctor->type = type;
    jsctor->returning = returning;
    jsctor->unique = unique;
    jsctor->absent_on_null = absent_on_null;
    jsctor->location = location;
 
    if (fexpr)
        placeholder = makeCaseTestExpr((Node *) fexpr);
    else
    {
        CaseTestExpr *cte = makeNode(CaseTestExpr);
 
        cte->typeId = intermediate_typid;
        cte->typeMod = -1;
        cte->collation = InvalidOid;
 
        placeholder = (Node *) cte;
    }
 
    coercion = coerceJsonFuncExpr(pstate, placeholder, returning, true);
 
    if (coercion != placeholder)
        jsctor->coercion = (Expr *) coercion;
 
    return (Node *) jsctor;
}

References JsonConstructorExpr::absent_on_null, generate_unaccent_rules::args, JsonConstructorExpr::args, coerceJsonFuncExpr(), JsonConstructorExpr::coercion, CaseTestExpr::collation, JsonReturning::format, JsonFormat::format_type, JsonConstructorExpr::func, InvalidOid, JS_FORMAT_JSONB, JsonConstructorExpr::location, makeCaseTestExpr(), makeNode, JsonConstructorExpr::returning, generate_unaccent_rules::type, JsonConstructorExpr::type, CaseTestExpr::typeId, CaseTestExpr::typeMod, and JsonConstructorExpr::unique.

Referenced by transformJsonAggConstructor(), transformJsonArrayConstructor(), transformJsonObjectConstructor(), transformJsonParseExpr(), transformJsonScalarExpr(), and transformJsonSerializeExpr().

ParseExprKindName()

const char* ParseExprKindName

(

ParseExprKind

exprKind

)

Definition at line 3070 of file parse_expr.c.

{
    switch (exprKind)
    {
        case EXPR_KIND_NONE:
            return "invalid expression context";
        case EXPR_KIND_OTHER:
            return "extension expression";
        case EXPR_KIND_JOIN_ON:
            return "JOIN/ON";
        case EXPR_KIND_JOIN_USING:
            return "JOIN/USING";
        case EXPR_KIND_FROM_SUBSELECT:
            return "sub-SELECT in FROM";
        case EXPR_KIND_FROM_FUNCTION:
            return "function in FROM";
        case EXPR_KIND_WHERE:
            return "WHERE";
        case EXPR_KIND_POLICY:
            return "POLICY";
        case EXPR_KIND_HAVING:
            return "HAVING";
        case EXPR_KIND_FILTER:
            return "FILTER";
        case EXPR_KIND_WINDOW_PARTITION:
            return "window PARTITION BY";
        case EXPR_KIND_WINDOW_ORDER:
            return "window ORDER BY";
        case EXPR_KIND_WINDOW_FRAME_RANGE:
            return "window RANGE";
        case EXPR_KIND_WINDOW_FRAME_ROWS:
            return "window ROWS";
        case EXPR_KIND_WINDOW_FRAME_GROUPS:
            return "window GROUPS";
        case EXPR_KIND_SELECT_TARGET:
            return "SELECT";
        case EXPR_KIND_INSERT_TARGET:
            return "INSERT";
        case EXPR_KIND_UPDATE_SOURCE:
        case EXPR_KIND_UPDATE_TARGET:
            return "UPDATE";
        case EXPR_KIND_MERGE_WHEN:
            return "MERGE WHEN";
        case EXPR_KIND_GROUP_BY:
            return "GROUP BY";
        case EXPR_KIND_ORDER_BY:
            return "ORDER BY";
        case EXPR_KIND_DISTINCT_ON:
            return "DISTINCT ON";
        case EXPR_KIND_LIMIT:
            return "LIMIT";
        case EXPR_KIND_OFFSET:
            return "OFFSET";
        case EXPR_KIND_RETURNING:
            return "RETURNING";
        case EXPR_KIND_VALUES:
        case EXPR_KIND_VALUES_SINGLE:
            return "VALUES";
        case EXPR_KIND_CHECK_CONSTRAINT:
        case EXPR_KIND_DOMAIN_CHECK:
            return "CHECK";
        case EXPR_KIND_COLUMN_DEFAULT:
        case EXPR_KIND_FUNCTION_DEFAULT:
            return "DEFAULT";
        case EXPR_KIND_INDEX_EXPRESSION:
            return "index expression";
        case EXPR_KIND_INDEX_PREDICATE:
            return "index predicate";
        case EXPR_KIND_STATS_EXPRESSION:
            return "statistics expression";
        case EXPR_KIND_ALTER_COL_TRANSFORM:
            return "USING";
        case EXPR_KIND_EXECUTE_PARAMETER:
            return "EXECUTE";
        case EXPR_KIND_TRIGGER_WHEN:
            return "WHEN";
        case EXPR_KIND_PARTITION_BOUND:
            return "partition bound";
        case EXPR_KIND_PARTITION_EXPRESSION:
            return "PARTITION BY";
        case EXPR_KIND_CALL_ARGUMENT:
            return "CALL";
        case EXPR_KIND_COPY_WHERE:
            return "WHERE";
        case EXPR_KIND_GENERATED_COLUMN:
            return "GENERATED AS";
        case EXPR_KIND_CYCLE_MARK:
            return "CYCLE";
 
            /*
             * There is intentionally no default: case here, so that the
             * compiler will warn if we add a new ParseExprKind without
             * extending this switch.  If we do see an unrecognized value at
             * runtime, we'll fall through to the "unrecognized" return.
             */
    }
    return "unrecognized expression kind";
}

References EXPR_KIND_ALTER_COL_TRANSFORM, EXPR_KIND_CALL_ARGUMENT, EXPR_KIND_CHECK_CONSTRAINT, EXPR_KIND_COLUMN_DEFAULT, EXPR_KIND_COPY_WHERE, EXPR_KIND_CYCLE_MARK, EXPR_KIND_DISTINCT_ON, EXPR_KIND_DOMAIN_CHECK, EXPR_KIND_EXECUTE_PARAMETER, EXPR_KIND_FILTER, EXPR_KIND_FROM_FUNCTION, EXPR_KIND_FROM_SUBSELECT, EXPR_KIND_FUNCTION_DEFAULT, EXPR_KIND_GENERATED_COLUMN, EXPR_KIND_GROUP_BY, EXPR_KIND_HAVING, EXPR_KIND_INDEX_EXPRESSION, EXPR_KIND_INDEX_PREDICATE, EXPR_KIND_INSERT_TARGET, EXPR_KIND_JOIN_ON, EXPR_KIND_JOIN_USING, EXPR_KIND_LIMIT, EXPR_KIND_MERGE_WHEN, EXPR_KIND_NONE, EXPR_KIND_OFFSET, EXPR_KIND_ORDER_BY, EXPR_KIND_OTHER, EXPR_KIND_PARTITION_BOUND, EXPR_KIND_PARTITION_EXPRESSION, EXPR_KIND_POLICY, EXPR_KIND_RETURNING, EXPR_KIND_SELECT_TARGET, EXPR_KIND_STATS_EXPRESSION, EXPR_KIND_TRIGGER_WHEN, EXPR_KIND_UPDATE_SOURCE, EXPR_KIND_UPDATE_TARGET, EXPR_KIND_VALUES, EXPR_KIND_VALUES_SINGLE, EXPR_KIND_WHERE, EXPR_KIND_WINDOW_FRAME_GROUPS, EXPR_KIND_WINDOW_FRAME_RANGE, EXPR_KIND_WINDOW_FRAME_ROWS, EXPR_KIND_WINDOW_ORDER, and EXPR_KIND_WINDOW_PARTITION.

Referenced by check_agglevels_and_constraints(), check_srf_call_placement(), checkTargetlistEntrySQL92(), findTargetlistEntrySQL92(), and transformWindowFuncCall().

transformAExprBetween()

static Node * transformAExprBetween ( ParseState *  pstate, A_Expr *  a  )

static

Definition at line 1283 of file parse_expr.c.

{
    Node       *aexpr;
    Node       *bexpr;
    Node       *cexpr;
    Node       *result;
    Node       *sub1;
    Node       *sub2;
    List       *args;
 
    /* Deconstruct A_Expr into three subexprs */
    aexpr = a->lexpr;
    args = castNode(List, a->rexpr);
    Assert(list_length(args) == 2);
    bexpr = (Node *) linitial(args);
    cexpr = (Node *) lsecond(args);
 
    /*
     * Build the equivalent comparison expression.  Make copies of
     * multiply-referenced subexpressions for safety.  (XXX this is really
     * wrong since it results in multiple runtime evaluations of what may be
     * volatile expressions ...)
     *
     * Ideally we would not use hard-wired operators here but instead use
     * opclasses.  However, mixed data types and other issues make this
     * difficult:
     * http://archives.postgresql.org/pgsql-hackers/2008-08/msg01142.php
     */
    switch (a->kind)
    {
        case AEXPR_BETWEEN:
            args = list_make2(makeSimpleA_Expr(AEXPR_OP, ">=",
                                               aexpr, bexpr,
                                               a->location),
                              makeSimpleA_Expr(AEXPR_OP, "<=",
                                               copyObject(aexpr), cexpr,
                                               a->location));
            result = (Node *) makeBoolExpr(AND_EXPR, args, a->location);
            break;
        case AEXPR_NOT_BETWEEN:
            args = list_make2(makeSimpleA_Expr(AEXPR_OP, "<",
                                               aexpr, bexpr,
                                               a->location),
                              makeSimpleA_Expr(AEXPR_OP, ">",
                                               copyObject(aexpr), cexpr,
                                               a->location));
            result = (Node *) makeBoolExpr(OR_EXPR, args, a->location);
            break;
        case AEXPR_BETWEEN_SYM:
            args = list_make2(makeSimpleA_Expr(AEXPR_OP, ">=",
                                               aexpr, bexpr,
                                               a->location),
                              makeSimpleA_Expr(AEXPR_OP, "<=",
                                               copyObject(aexpr), cexpr,
                                               a->location));
            sub1 = (Node *) makeBoolExpr(AND_EXPR, args, a->location);
            args = list_make2(makeSimpleA_Expr(AEXPR_OP, ">=",
                                               copyObject(aexpr), copyObject(cexpr),
                                               a->location),
                              makeSimpleA_Expr(AEXPR_OP, "<=",
                                               copyObject(aexpr), copyObject(bexpr),
                                               a->location));
            sub2 = (Node *) makeBoolExpr(AND_EXPR, args, a->location);
            args = list_make2(sub1, sub2);
            result = (Node *) makeBoolExpr(OR_EXPR, args, a->location);
            break;
        case AEXPR_NOT_BETWEEN_SYM:
            args = list_make2(makeSimpleA_Expr(AEXPR_OP, "<",
                                               aexpr, bexpr,
                                               a->location),
                              makeSimpleA_Expr(AEXPR_OP, ">",
                                               copyObject(aexpr), cexpr,
                                               a->location));
            sub1 = (Node *) makeBoolExpr(OR_EXPR, args, a->location);
            args = list_make2(makeSimpleA_Expr(AEXPR_OP, "<",
                                               copyObject(aexpr), copyObject(cexpr),
                                               a->location),
                              makeSimpleA_Expr(AEXPR_OP, ">",
                                               copyObject(aexpr), copyObject(bexpr),
                                               a->location));
            sub2 = (Node *) makeBoolExpr(OR_EXPR, args, a->location);
            args = list_make2(sub1, sub2);
            result = (Node *) makeBoolExpr(AND_EXPR, args, a->location);
            break;
        default:
            elog(ERROR, "unrecognized A_Expr kind: %d", a->kind);
            result = NULL;      /* keep compiler quiet */
            break;
    }
 
    return transformExprRecurse(pstate, result);
}

References a, AEXPR_BETWEEN, AEXPR_BETWEEN_SYM, AEXPR_NOT_BETWEEN, AEXPR_NOT_BETWEEN_SYM, AEXPR_OP, AND_EXPR, generate_unaccent_rules::args, Assert(), castNode, copyObject, elog, ERROR, linitial, list_length(), list_make2, lsecond, makeBoolExpr(), makeSimpleA_Expr(), OR_EXPR, and transformExprRecurse().

Referenced by transformExprRecurse().

transformAExprDistinct()

static Node * transformAExprDistinct ( ParseState *  pstate, A_Expr *  a  )

static

Definition at line 1032 of file parse_expr.c.

{
    Node       *lexpr = a->lexpr;
    Node       *rexpr = a->rexpr;
    Node       *result;
 
    /*
     * If either input is an undecorated NULL literal, transform to a NullTest
     * on the other input. That's simpler to process than a full DistinctExpr,
     * and it avoids needing to require that the datatype have an = operator.
     */
    if (exprIsNullConstant(rexpr))
        return make_nulltest_from_distinct(pstate, a, lexpr);
    if (exprIsNullConstant(lexpr))
        return make_nulltest_from_distinct(pstate, a, rexpr);
 
    lexpr = transformExprRecurse(pstate, lexpr);
    rexpr = transformExprRecurse(pstate, rexpr);
 
    if (lexpr && IsA(lexpr, RowExpr) &&
        rexpr && IsA(rexpr, RowExpr))
    {
        /* ROW() op ROW() is handled specially */
        result = make_row_distinct_op(pstate, a->name,
                                      (RowExpr *) lexpr,
                                      (RowExpr *) rexpr,
                                      a->location);
    }
    else
    {
        /* Ordinary scalar operator */
        result = (Node *) make_distinct_op(pstate,
                                           a->name,
                                           lexpr,
                                           rexpr,
                                           a->location);
    }
 
    /*
     * If it's NOT DISTINCT, we first build a DistinctExpr and then stick a
     * NOT on top.
     */
    if (a->kind == AEXPR_NOT_DISTINCT)
        result = (Node *) makeBoolExpr(NOT_EXPR,
                                       list_make1(result),
                                       a->location);
 
    return result;
}

References a, AEXPR_NOT_DISTINCT, exprIsNullConstant(), IsA, list_make1, make_distinct_op(), make_nulltest_from_distinct(), make_row_distinct_op(), makeBoolExpr(), NOT_EXPR, and transformExprRecurse().

Referenced by transformExprRecurse().

transformAExprIn()

static Node * transformAExprIn ( ParseState *  pstate, A_Expr *  a  )

static

Definition at line 1125 of file parse_expr.c.

{
    Node       *result = NULL;
    Node       *lexpr;
    List       *rexprs;
    List       *rvars;
    List       *rnonvars;
    bool        useOr;
    ListCell   *l;
 
    /*
     * If the operator is <>, combine with AND not OR.
     */
    if (strcmp(strVal(linitial(a->name)), "<>") == 0)
        useOr = false;
    else
        useOr = true;
 
    /*
     * We try to generate a ScalarArrayOpExpr from IN/NOT IN, but this is only
     * possible if there is a suitable array type available.  If not, we fall
     * back to a boolean condition tree with multiple copies of the lefthand
     * expression.  Also, any IN-list items that contain Vars are handled as
     * separate boolean conditions, because that gives the planner more scope
     * for optimization on such clauses.
     *
     * First step: transform all the inputs, and detect whether any contain
     * Vars.
     */
    lexpr = transformExprRecurse(pstate, a->lexpr);
    rexprs = rvars = rnonvars = NIL;
    foreach(l, (List *) a->rexpr)
    {
        Node       *rexpr = transformExprRecurse(pstate, lfirst(l));
 
        rexprs = lappend(rexprs, rexpr);
        if (contain_vars_of_level(rexpr, 0))
            rvars = lappend(rvars, rexpr);
        else
            rnonvars = lappend(rnonvars, rexpr);
    }
 
    /*
     * ScalarArrayOpExpr is only going to be useful if there's more than one
     * non-Var righthand item.
     */
    if (list_length(rnonvars) > 1)
    {
        List       *allexprs;
        Oid         scalar_type;
        Oid         array_type;
 
        /*
         * Try to select a common type for the array elements.  Note that
         * since the LHS' type is first in the list, it will be preferred when
         * there is doubt (eg, when all the RHS items are unknown literals).
         *
         * Note: use list_concat here not lcons, to avoid damaging rnonvars.
         */
        allexprs = list_concat(list_make1(lexpr), rnonvars);
        scalar_type = select_common_type(pstate, allexprs, NULL, NULL);
 
        /* We have to verify that the selected type actually works */
        if (OidIsValid(scalar_type) &&
            !verify_common_type(scalar_type, allexprs))
            scalar_type = InvalidOid;
 
        /*
         * Do we have an array type to use?  Aside from the case where there
         * isn't one, we don't risk using ScalarArrayOpExpr when the common
         * type is RECORD, because the RowExpr comparison logic below can cope
         * with some cases of non-identical row types.
         */
        if (OidIsValid(scalar_type) && scalar_type != RECORDOID)
            array_type = get_array_type(scalar_type);
        else
            array_type = InvalidOid;
        if (array_type != InvalidOid)
        {
            /*
             * OK: coerce all the right-hand non-Var inputs to the common type
             * and build an ArrayExpr for them.
             */
            List       *aexprs;
            ArrayExpr  *newa;
 
            aexprs = NIL;
            foreach(l, rnonvars)
            {
                Node       *rexpr = (Node *) lfirst(l);
 
                rexpr = coerce_to_common_type(pstate, rexpr,
                                              scalar_type,
                                              "IN");
                aexprs = lappend(aexprs, rexpr);
            }
            newa = makeNode(ArrayExpr);
            newa->array_typeid = array_type;
            /* array_collid will be set by parse_collate.c */
            newa->element_typeid = scalar_type;
            newa->elements = aexprs;
            newa->multidims = false;
            newa->location = -1;
 
            result = (Node *) make_scalar_array_op(pstate,
                                                   a->name,
                                                   useOr,
                                                   lexpr,
                                                   (Node *) newa,
                                                   a->location);
 
            /* Consider only the Vars (if any) in the loop below */
            rexprs = rvars;
        }
    }
 
    /*
     * Must do it the hard way, ie, with a boolean expression tree.
     */
    foreach(l, rexprs)
    {
        Node       *rexpr = (Node *) lfirst(l);
        Node       *cmp;
 
        if (IsA(lexpr, RowExpr) &&
            IsA(rexpr, RowExpr))
        {
            /* ROW() op ROW() is handled specially */
            cmp = make_row_comparison_op(pstate,
                                         a->name,
                                         copyObject(((RowExpr *) lexpr)->args),
                                         ((RowExpr *) rexpr)->args,
                                         a->location);
        }
        else
        {
            /* Ordinary scalar operator */
            cmp = (Node *) make_op(pstate,
                                   a->name,
                                   copyObject(lexpr),
                                   rexpr,
                                   pstate->p_last_srf,
                                   a->location);
        }
 
        cmp = coerce_to_boolean(pstate, cmp, "IN");
        if (result == NULL)
            result = cmp;
        else
            result = (Node *) makeBoolExpr(useOr ? OR_EXPR : AND_EXPR,
                                           list_make2(result, cmp),
                                           a->location);
    }
 
    return result;
}

References a, AND_EXPR, generate_unaccent_rules::args, ArrayExpr::array_typeid, cmp(), coerce_to_boolean(), coerce_to_common_type(), contain_vars_of_level(), copyObject, ArrayExpr::element_typeid, ArrayExpr::elements, get_array_type(), InvalidOid, IsA, lappend(), lfirst, linitial, list_concat(), list_length(), list_make1, list_make2, ArrayExpr::location, make_op(), make_row_comparison_op(), make_scalar_array_op(), makeBoolExpr(), makeNode, ArrayExpr::multidims, NIL, OidIsValid, OR_EXPR, ParseState::p_last_srf, select_common_type(), strVal, transformExprRecurse(), and verify_common_type().

Referenced by transformExprRecurse().

transformAExprNullIf()

static Node * transformAExprNullIf ( ParseState *  pstate, A_Expr *  a  )

static

Definition at line 1083 of file parse_expr.c.

{
    Node       *lexpr = transformExprRecurse(pstate, a->lexpr);
    Node       *rexpr = transformExprRecurse(pstate, a->rexpr);
    OpExpr     *result;
 
    result = (OpExpr *) make_op(pstate,
                                a->name,
                                lexpr,
                                rexpr,
                                pstate->p_last_srf,
                                a->location);
 
    /*
     * The comparison operator itself should yield boolean ...
     */
    if (result->opresulttype != BOOLOID)
        ereport(ERROR,
                (errcode(ERRCODE_DATATYPE_MISMATCH),
                 errmsg("NULLIF requires = operator to yield boolean"),
                 parser_errposition(pstate, a->location)));
    if (result->opretset)
        ereport(ERROR,
                (errcode(ERRCODE_DATATYPE_MISMATCH),
        /* translator: %s is name of a SQL construct, eg NULLIF */
                 errmsg("%s must not return a set", "NULLIF"),
                 parser_errposition(pstate, a->location)));
 
    /*
     * ... but the NullIfExpr will yield the first operand's type.
     */
    result->opresulttype = exprType((Node *) linitial(result->args));
 
    /*
     * We rely on NullIfExpr and OpExpr being the same struct
     */
    NodeSetTag(result, T_NullIfExpr);
 
    return (Node *) result;
}

References a, OpExpr::args, ereport, errcode(), errmsg(), ERROR, exprType(), linitial, make_op(), NodeSetTag, OpExpr::opresulttype, OpExpr::opretset, ParseState::p_last_srf, parser_errposition(), T_NullIfExpr, and transformExprRecurse().

Referenced by transformExprRecurse().

transformAExprOp()

static Node * transformAExprOp ( ParseState *  pstate, A_Expr *  a  )

static

Definition at line 923 of file parse_expr.c.

{
    Node       *lexpr = a->lexpr;
    Node       *rexpr = a->rexpr;
    Node       *result;
 
    /*
     * Special-case "foo = NULL" and "NULL = foo" for compatibility with
     * standards-broken products (like Microsoft's).  Turn these into IS NULL
     * exprs. (If either side is a CaseTestExpr, then the expression was
     * generated internally from a CASE-WHEN expression, and
     * transform_null_equals does not apply.)
     */
    if (Transform_null_equals &&
        list_length(a->name) == 1 &&
        strcmp(strVal(linitial(a->name)), "=") == 0 &&
        (exprIsNullConstant(lexpr) || exprIsNullConstant(rexpr)) &&
        (!IsA(lexpr, CaseTestExpr) && !IsA(rexpr, CaseTestExpr)))
    {
        NullTest   *n = makeNode(NullTest);
 
        n->nulltesttype = IS_NULL;
        n->location = a->location;
 
        if (exprIsNullConstant(lexpr))
            n->arg = (Expr *) rexpr;
        else
            n->arg = (Expr *) lexpr;
 
        result = transformExprRecurse(pstate, (Node *) n);
    }
    else if (lexpr && IsA(lexpr, RowExpr) &&
             rexpr && IsA(rexpr, SubLink) &&
             ((SubLink *) rexpr)->subLinkType == EXPR_SUBLINK)
    {
        /*
         * Convert "row op subselect" into a ROWCOMPARE sublink. Formerly the
         * grammar did this, but now that a row construct is allowed anywhere
         * in expressions, it's easier to do it here.
         */
        SubLink    *s = (SubLink *) rexpr;
 
        s->subLinkType = ROWCOMPARE_SUBLINK;
        s->testexpr = lexpr;
        s->operName = a->name;
        s->location = a->location;
        result = transformExprRecurse(pstate, (Node *) s);
    }
    else if (lexpr && IsA(lexpr, RowExpr) &&
             rexpr && IsA(rexpr, RowExpr))
    {
        /* ROW() op ROW() is handled specially */
        lexpr = transformExprRecurse(pstate, lexpr);
        rexpr = transformExprRecurse(pstate, rexpr);
 
        result = make_row_comparison_op(pstate,
                                        a->name,
                                        castNode(RowExpr, lexpr)->args,
                                        castNode(RowExpr, rexpr)->args,
                                        a->location);
    }
    else
    {
        /* Ordinary scalar operator */
        Node       *last_srf = pstate->p_last_srf;
 
        lexpr = transformExprRecurse(pstate, lexpr);
        rexpr = transformExprRecurse(pstate, rexpr);
 
        result = (Node *) make_op(pstate,
                                  a->name,
                                  lexpr,
                                  rexpr,
                                  last_srf,
                                  a->location);
    }
 
    return result;
}

References a, NullTest::arg, generate_unaccent_rules::args, castNode, EXPR_SUBLINK, exprIsNullConstant(), IS_NULL, IsA, linitial, list_length(), SubLink::location, NullTest::location, make_op(), make_row_comparison_op(), makeNode, NullTest::nulltesttype, SubLink::operName, ParseState::p_last_srf, ROWCOMPARE_SUBLINK, strVal, SubLink::subLinkType, SubLink::testexpr, Transform_null_equals, and transformExprRecurse().

Referenced by transformExprRecurse().

transformAExprOpAll()

static Node * transformAExprOpAll ( ParseState *  pstate, A_Expr *  a  )

static

Definition at line 1018 of file parse_expr.c.

{
    Node       *lexpr = transformExprRecurse(pstate, a->lexpr);
    Node       *rexpr = transformExprRecurse(pstate, a->rexpr);
 
    return (Node *) make_scalar_array_op(pstate,
                                         a->name,
                                         false,
                                         lexpr,
                                         rexpr,
                                         a->location);
}

References a, make_scalar_array_op(), and transformExprRecurse().

Referenced by transformExprRecurse().

transformAExprOpAny()

static Node * transformAExprOpAny ( ParseState *  pstate, A_Expr *  a  )

static

Definition at line 1004 of file parse_expr.c.

{
    Node       *lexpr = transformExprRecurse(pstate, a->lexpr);
    Node       *rexpr = transformExprRecurse(pstate, a->rexpr);
 
    return (Node *) make_scalar_array_op(pstate,
                                         a->name,
                                         true,
                                         lexpr,
                                         rexpr,
                                         a->location);
}

References a, make_scalar_array_op(), and transformExprRecurse().

Referenced by transformExprRecurse().

transformArrayExpr()

static Node * transformArrayExpr ( ParseState *  pstate, A_ArrayExpr *  a, Oid  array_type, Oid  element_type, int32  typmod  )

static

Definition at line 1988 of file parse_expr.c.

{
    ArrayExpr  *newa = makeNode(ArrayExpr);
    List       *newelems = NIL;
    List       *newcoercedelems = NIL;
    ListCell   *element;
    Oid         coerce_type;
    bool        coerce_hard;
 
    /*
     * Transform the element expressions
     *
     * Assume that the array is one-dimensional unless we find an array-type
     * element expression.
     */
    newa->multidims = false;
    foreach(element, a->elements)
    {
        Node       *e = (Node *) lfirst(element);
        Node       *newe;
 
        /*
         * If an element is itself an A_ArrayExpr, recurse directly so that we
         * can pass down any target type we were given.
         */
        if (IsA(e, A_ArrayExpr))
        {
            newe = transformArrayExpr(pstate,
                                      (A_ArrayExpr *) e,
                                      array_type,
                                      element_type,
                                      typmod);
            /* we certainly have an array here */
            Assert(array_type == InvalidOid || array_type == exprType(newe));
            newa->multidims = true;
        }
        else
        {
            newe = transformExprRecurse(pstate, e);
 
            /*
             * Check for sub-array expressions, if we haven't already found
             * one.
             */
            if (!newa->multidims && type_is_array(exprType(newe)))
                newa->multidims = true;
        }
 
        newelems = lappend(newelems, newe);
    }
 
    /*
     * Select a target type for the elements.
     *
     * If we haven't been given a target array type, we must try to deduce a
     * common type based on the types of the individual elements present.
     */
    if (OidIsValid(array_type))
    {
        /* Caller must ensure array_type matches element_type */
        Assert(OidIsValid(element_type));
        coerce_type = (newa->multidims ? array_type : element_type);
        coerce_hard = true;
    }
    else
    {
        /* Can't handle an empty array without a target type */
        if (newelems == NIL)
            ereport(ERROR,
                    (errcode(ERRCODE_INDETERMINATE_DATATYPE),
                     errmsg("cannot determine type of empty array"),
                     errhint("Explicitly cast to the desired type, "
                             "for example ARRAY[]::integer[]."),
                     parser_errposition(pstate, a->location)));
 
        /* Select a common type for the elements */
        coerce_type = select_common_type(pstate, newelems, "ARRAY", NULL);
 
        if (newa->multidims)
        {
            array_type = coerce_type;
            element_type = get_element_type(array_type);
            if (!OidIsValid(element_type))
                ereport(ERROR,
                        (errcode(ERRCODE_UNDEFINED_OBJECT),
                         errmsg("could not find element type for data type %s",
                                format_type_be(array_type)),
                         parser_errposition(pstate, a->location)));
        }
        else
        {
            element_type = coerce_type;
            array_type = get_array_type(element_type);
            if (!OidIsValid(array_type))
                ereport(ERROR,
                        (errcode(ERRCODE_UNDEFINED_OBJECT),
                         errmsg("could not find array type for data type %s",
                                format_type_be(element_type)),
                         parser_errposition(pstate, a->location)));
        }
        coerce_hard = false;
    }
 
    /*
     * Coerce elements to target type
     *
     * If the array has been explicitly cast, then the elements are in turn
     * explicitly coerced.
     *
     * If the array's type was merely derived from the common type of its
     * elements, then the elements are implicitly coerced to the common type.
     * This is consistent with other uses of select_common_type().
     */
    foreach(element, newelems)
    {
        Node       *e = (Node *) lfirst(element);
        Node       *newe;
 
        if (coerce_hard)
        {
            newe = coerce_to_target_type(pstate, e,
                                         exprType(e),
                                         coerce_type,
                                         typmod,
                                         COERCION_EXPLICIT,
                                         COERCE_EXPLICIT_CAST,
                                         -1);
            if (newe == NULL)
                ereport(ERROR,
                        (errcode(ERRCODE_CANNOT_COERCE),
                         errmsg("cannot cast type %s to %s",
                                format_type_be(exprType(e)),
                                format_type_be(coerce_type)),
                         parser_errposition(pstate, exprLocation(e))));
        }
        else
            newe = coerce_to_common_type(pstate, e,
                                         coerce_type,
                                         "ARRAY");
        newcoercedelems = lappend(newcoercedelems, newe);
    }
 
    newa->array_typeid = array_type;
    /* array_collid will be set by parse_collate.c */
    newa->element_typeid = element_type;
    newa->elements = newcoercedelems;
    newa->location = a->location;
 
    return (Node *) newa;
}

References a, ArrayExpr::array_typeid, Assert(), COERCE_EXPLICIT_CAST, coerce_to_common_type(), coerce_to_target_type(), coerce_type(), COERCION_EXPLICIT, element(), ArrayExpr::element_typeid, ArrayExpr::elements, ereport, errcode(), errhint(), errmsg(), ERROR, exprLocation(), exprType(), format_type_be(), get_array_type(), get_element_type(), InvalidOid, IsA, lappend(), lfirst, ArrayExpr::location, makeNode, ArrayExpr::multidims, NIL, OidIsValid, parser_errposition(), select_common_type(), transformExprRecurse(), and type_is_array.

Referenced by transformExprRecurse(), and transformTypeCast().

transformBooleanTest()

static Node * transformBooleanTest ( ParseState *  pstate, BooleanTest *  b  )

static

Definition at line 2484 of file parse_expr.c.

{
    const char *clausename;
 
    switch (b->booltesttype)
    {
        case IS_TRUE:
            clausename = "IS TRUE";
            break;
        case IS_NOT_TRUE:
            clausename = "IS NOT TRUE";
            break;
        case IS_FALSE:
            clausename = "IS FALSE";
            break;
        case IS_NOT_FALSE:
            clausename = "IS NOT FALSE";
            break;
        case IS_UNKNOWN:
            clausename = "IS UNKNOWN";
            break;
        case IS_NOT_UNKNOWN:
            clausename = "IS NOT UNKNOWN";
            break;
        default:
            elog(ERROR, "unrecognized booltesttype: %d",
                 (int) b->booltesttype);
            clausename = NULL;  /* keep compiler quiet */
    }
 
    b->arg = (Expr *) transformExprRecurse(pstate, (Node *) b->arg);
 
    b->arg = (Expr *) coerce_to_boolean(pstate,
                                        (Node *) b->arg,
                                        clausename);
 
    return (Node *) b;
}

References b, coerce_to_boolean(), elog, ERROR, IS_FALSE, IS_NOT_FALSE, IS_NOT_TRUE, IS_NOT_UNKNOWN, IS_TRUE, IS_UNKNOWN, and transformExprRecurse().

Referenced by transformExprRecurse().

transformBoolExpr()

static Node * transformBoolExpr ( ParseState *  pstate, BoolExpr *  a  )

static

Definition at line 1377 of file parse_expr.c.

{
    List       *args = NIL;
    const char *opname;
    ListCell   *lc;
 
    switch (a->boolop)
    {
        case AND_EXPR:
            opname = "AND";
            break;
        case OR_EXPR:
            opname = "OR";
            break;
        case NOT_EXPR:
            opname = "NOT";
            break;
        default:
            elog(ERROR, "unrecognized boolop: %d", (int) a->boolop);
            opname = NULL;      /* keep compiler quiet */
            break;
    }
 
    foreach(lc, a->args)
    {
        Node       *arg = (Node *) lfirst(lc);
 
        arg = transformExprRecurse(pstate, arg);
        arg = coerce_to_boolean(pstate, arg, opname);
        args = lappend(args, arg);
    }
 
    return (Node *) makeBoolExpr(a->boolop, args, a->location);
}

References a, AND_EXPR, arg, generate_unaccent_rules::args, coerce_to_boolean(), elog, ERROR, lappend(), lfirst, makeBoolExpr(), NIL, NOT_EXPR, OR_EXPR, and transformExprRecurse().

Referenced by transformExprRecurse().

transformCaseExpr()

static Node * transformCaseExpr ( ParseState *  pstate, CaseExpr *  c  )

static

Definition at line 1606 of file parse_expr.c.

{
    CaseExpr   *newc = makeNode(CaseExpr);
    Node       *last_srf = pstate->p_last_srf;
    Node       *arg;
    CaseTestExpr *placeholder;
    List       *newargs;
    List       *resultexprs;
    ListCell   *l;
    Node       *defresult;
    Oid         ptype;
 
    /* transform the test expression, if any */
    arg = transformExprRecurse(pstate, (Node *) c->arg);
 
    /* generate placeholder for test expression */
    if (arg)
    {
        /*
         * If test expression is an untyped literal, force it to text. We have
         * to do something now because we won't be able to do this coercion on
         * the placeholder.  This is not as flexible as what was done in 7.4
         * and before, but it's good enough to handle the sort of silly coding
         * commonly seen.
         */
        if (exprType(arg) == UNKNOWNOID)
            arg = coerce_to_common_type(pstate, arg, TEXTOID, "CASE");
 
        /*
         * Run collation assignment on the test expression so that we know
         * what collation to mark the placeholder with.  In principle we could
         * leave it to parse_collate.c to do that later, but propagating the
         * result to the CaseTestExpr would be unnecessarily complicated.
         */
        assign_expr_collations(pstate, arg);
 
        placeholder = makeNode(CaseTestExpr);
        placeholder->typeId = exprType(arg);
        placeholder->typeMod = exprTypmod(arg);
        placeholder->collation = exprCollation(arg);
    }
    else
        placeholder = NULL;
 
    newc->arg = (Expr *) arg;
 
    /* transform the list of arguments */
    newargs = NIL;
    resultexprs = NIL;
    foreach(l, c->args)
    {
        CaseWhen   *w = lfirst_node(CaseWhen, l);
        CaseWhen   *neww = makeNode(CaseWhen);
        Node       *warg;
 
        warg = (Node *) w->expr;
        if (placeholder)
        {
            /* shorthand form was specified, so expand... */
            warg = (Node *) makeSimpleA_Expr(AEXPR_OP, "=",
                                             (Node *) placeholder,
                                             warg,
                                             w->location);
        }
        neww->expr = (Expr *) transformExprRecurse(pstate, warg);
 
        neww->expr = (Expr *) coerce_to_boolean(pstate,
                                                (Node *) neww->expr,
                                                "CASE/WHEN");
 
        warg = (Node *) w->result;
        neww->result = (Expr *) transformExprRecurse(pstate, warg);
        neww->location = w->location;
 
        newargs = lappend(newargs, neww);
        resultexprs = lappend(resultexprs, neww->result);
    }
 
    newc->args = newargs;
 
    /* transform the default clause */
    defresult = (Node *) c->defresult;
    if (defresult == NULL)
    {
        A_Const    *n = makeNode(A_Const);
 
        n->isnull = true;
        n->location = -1;
        defresult = (Node *) n;
    }
    newc->defresult = (Expr *) transformExprRecurse(pstate, defresult);
 
    /*
     * Note: default result is considered the most significant type in
     * determining preferred type. This is how the code worked before, but it
     * seems a little bogus to me --- tgl
     */
    resultexprs = lcons(newc->defresult, resultexprs);
 
    ptype = select_common_type(pstate, resultexprs, "CASE", NULL);
    Assert(OidIsValid(ptype));
    newc->casetype = ptype;
    /* casecollid will be set by parse_collate.c */
 
    /* Convert default result clause, if necessary */
    newc->defresult = (Expr *)
        coerce_to_common_type(pstate,
                              (Node *) newc->defresult,
                              ptype,
                              "CASE/ELSE");
 
    /* Convert when-clause results, if necessary */
    foreach(l, newc->args)
    {
        CaseWhen   *w = (CaseWhen *) lfirst(l);
 
        w->result = (Expr *)
            coerce_to_common_type(pstate,
                                  (Node *) w->result,
                                  ptype,
                                  "CASE/WHEN");
    }
 
    /* if any subexpression contained a SRF, complain */
    if (pstate->p_last_srf != last_srf)
        ereport(ERROR,
                (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
        /* translator: %s is name of a SQL construct, eg GROUP BY */
                 errmsg("set-returning functions are not allowed in %s",
                        "CASE"),
                 errhint("You might be able to move the set-returning function into a LATERAL FROM item."),
                 parser_errposition(pstate,
                                    exprLocation(pstate->p_last_srf))));
 
    newc->location = c->location;
 
    return (Node *) newc;
}

References AEXPR_OP, arg, CaseExpr::arg, CaseExpr::args, Assert(), assign_expr_collations(), CaseExpr::casetype, coerce_to_boolean(), coerce_to_common_type(), CaseTestExpr::collation, CaseExpr::defresult, ereport, errcode(), errhint(), errmsg(), ERROR, CaseWhen::expr, exprCollation(), exprLocation(), exprType(), exprTypmod(), if(), A_Const::isnull, lappend(), lcons(), lfirst, lfirst_node, A_Const::location, CaseExpr::location, CaseWhen::location, makeNode, makeSimpleA_Expr(), NIL, OidIsValid, ParseState::p_last_srf, parser_errposition(), CaseWhen::result, select_common_type(), transformExprRecurse(), CaseTestExpr::typeId, and CaseTestExpr::typeMod.

Referenced by transformExprRecurse().

transformCoalesceExpr()

static Node * transformCoalesceExpr ( ParseState *  pstate, CoalesceExpr *  c  )

static

Definition at line 2171 of file parse_expr.c.

{
    CoalesceExpr *newc = makeNode(CoalesceExpr);
    Node       *last_srf = pstate->p_last_srf;
    List       *newargs = NIL;
    List       *newcoercedargs = NIL;
    ListCell   *args;
 
    foreach(args, c->args)
    {
        Node       *e = (Node *) lfirst(args);
        Node       *newe;
 
        newe = transformExprRecurse(pstate, e);
        newargs = lappend(newargs, newe);
    }
 
    newc->coalescetype = select_common_type(pstate, newargs, "COALESCE", NULL);
    /* coalescecollid will be set by parse_collate.c */
 
    /* Convert arguments if necessary */
    foreach(args, newargs)
    {
        Node       *e = (Node *) lfirst(args);
        Node       *newe;
 
        newe = coerce_to_common_type(pstate, e,
                                     newc->coalescetype,
                                     "COALESCE");
        newcoercedargs = lappend(newcoercedargs, newe);
    }
 
    /* if any subexpression contained a SRF, complain */
    if (pstate->p_last_srf != last_srf)
        ereport(ERROR,
                (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
        /* translator: %s is name of a SQL construct, eg GROUP BY */
                 errmsg("set-returning functions are not allowed in %s",
                        "COALESCE"),
                 errhint("You might be able to move the set-returning function into a LATERAL FROM item."),
                 parser_errposition(pstate,
                                    exprLocation(pstate->p_last_srf))));
 
    newc->args = newcoercedargs;
    newc->location = c->location;
    return (Node *) newc;
}

References generate_unaccent_rules::args, CoalesceExpr::args, CoalesceExpr::coalescetype, coerce_to_common_type(), ereport, errcode(), errhint(), errmsg(), ERROR, exprLocation(), lappend(), lfirst, CoalesceExpr::location, makeNode, NIL, ParseState::p_last_srf, parser_errposition(), select_common_type(), and transformExprRecurse().

Referenced by transformExprRecurse().

transformCollateClause()

static Node * transformCollateClause ( ParseState *  pstate, CollateClause *  c  )

static

Definition at line 2727 of file parse_expr.c.

{
    CollateExpr *newc;
    Oid         argtype;
 
    newc = makeNode(CollateExpr);
    newc->arg = (Expr *) transformExprRecurse(pstate, c->arg);
 
    argtype = exprType((Node *) newc->arg);
 
    /*
     * The unknown type is not collatable, but coerce_type() takes care of it
     * separately, so we'll let it go here.
     */
    if (!type_is_collatable(argtype) && argtype != UNKNOWNOID)
        ereport(ERROR,
                (errcode(ERRCODE_DATATYPE_MISMATCH),
                 errmsg("collations are not supported by type %s",
                        format_type_be(argtype)),
                 parser_errposition(pstate, c->location)));
 
    newc->collOid = LookupCollation(pstate, c->collname, c->location);
    newc->location = c->location;
 
    return (Node *) newc;
}

References CollateExpr::arg, CollateExpr::collOid, ereport, errcode(), errmsg(), ERROR, exprType(), format_type_be(), CollateExpr::location, LookupCollation(), makeNode, parser_errposition(), transformExprRecurse(), and type_is_collatable().

Referenced by transformExprRecurse().

transformColumnRef()

static Node * transformColumnRef ( ParseState *  pstate, ColumnRef *  cref  )

static

Definition at line 501 of file parse_expr.c.

{
    Node       *node = NULL;
    char       *nspname = NULL;
    char       *relname = NULL;
    char       *colname = NULL;
    ParseNamespaceItem *nsitem;
    int         levels_up;
    enum
    {
        CRERR_NO_COLUMN,
        CRERR_NO_RTE,
        CRERR_WRONG_DB,
        CRERR_TOO_MANY
    }           crerr = CRERR_NO_COLUMN;
    const char *err;
 
    /*
     * Check to see if the column reference is in an invalid place within the
     * query.  We allow column references in most places, except in default
     * expressions and partition bound expressions.
     */
    err = NULL;
    switch (pstate->p_expr_kind)
    {
        case EXPR_KIND_NONE:
            Assert(false);      /* can't happen */
            break;
        case EXPR_KIND_OTHER:
        case EXPR_KIND_JOIN_ON:
        case EXPR_KIND_JOIN_USING:
        case EXPR_KIND_FROM_SUBSELECT:
        case EXPR_KIND_FROM_FUNCTION:
        case EXPR_KIND_WHERE:
        case EXPR_KIND_POLICY:
        case EXPR_KIND_HAVING:
        case EXPR_KIND_FILTER:
        case EXPR_KIND_WINDOW_PARTITION:
        case EXPR_KIND_WINDOW_ORDER:
        case EXPR_KIND_WINDOW_FRAME_RANGE:
        case EXPR_KIND_WINDOW_FRAME_ROWS:
        case EXPR_KIND_WINDOW_FRAME_GROUPS:
        case EXPR_KIND_SELECT_TARGET:
        case EXPR_KIND_INSERT_TARGET:
        case EXPR_KIND_UPDATE_SOURCE:
        case EXPR_KIND_UPDATE_TARGET:
        case EXPR_KIND_MERGE_WHEN:
        case EXPR_KIND_GROUP_BY:
        case EXPR_KIND_ORDER_BY:
        case EXPR_KIND_DISTINCT_ON:
        case EXPR_KIND_LIMIT:
        case EXPR_KIND_OFFSET:
        case EXPR_KIND_RETURNING:
        case EXPR_KIND_VALUES:
        case EXPR_KIND_VALUES_SINGLE:
        case EXPR_KIND_CHECK_CONSTRAINT:
        case EXPR_KIND_DOMAIN_CHECK:
        case EXPR_KIND_FUNCTION_DEFAULT:
        case EXPR_KIND_INDEX_EXPRESSION:
        case EXPR_KIND_INDEX_PREDICATE:
        case EXPR_KIND_STATS_EXPRESSION:
        case EXPR_KIND_ALTER_COL_TRANSFORM:
        case EXPR_KIND_EXECUTE_PARAMETER:
        case EXPR_KIND_TRIGGER_WHEN:
        case EXPR_KIND_PARTITION_EXPRESSION:
        case EXPR_KIND_CALL_ARGUMENT:
        case EXPR_KIND_COPY_WHERE:
        case EXPR_KIND_GENERATED_COLUMN:
        case EXPR_KIND_CYCLE_MARK:
            /* okay */
            break;
 
        case EXPR_KIND_COLUMN_DEFAULT:
            err = _("cannot use column reference in DEFAULT expression");
            break;
        case EXPR_KIND_PARTITION_BOUND:
            err = _("cannot use column reference in partition bound expression");
            break;
 
            /*
             * There is intentionally no default: case here, so that the
             * compiler will warn if we add a new ParseExprKind without
             * extending this switch.  If we do see an unrecognized value at
             * runtime, the behavior will be the same as for EXPR_KIND_OTHER,
             * which is sane anyway.
             */
    }
    if (err)
        ereport(ERROR,
                (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                 errmsg_internal("%s", err),
                 parser_errposition(pstate, cref->location)));
 
    /*
     * Give the PreParseColumnRefHook, if any, first shot.  If it returns
     * non-null then that's all, folks.
     */
    if (pstate->p_pre_columnref_hook != NULL)
    {
        node = pstate->p_pre_columnref_hook(pstate, cref);
        if (node != NULL)
            return node;
    }
 
    /*----------
     * The allowed syntaxes are:
     *
     * A        First try to resolve as unqualified column name;
     *          if no luck, try to resolve as unqualified table name (A.*).
     * A.B      A is an unqualified table name; B is either a
     *          column or function name (trying column name first).
     * A.B.C    schema A, table B, col or func name C.
     * A.B.C.D  catalog A, schema B, table C, col or func D.
     * A.*      A is an unqualified table name; means whole-row value.
     * A.B.*    whole-row value of table B in schema A.
     * A.B.C.*  whole-row value of table C in schema B in catalog A.
     *
     * We do not need to cope with bare "*"; that will only be accepted by
     * the grammar at the top level of a SELECT list, and transformTargetList
     * will take care of it before it ever gets here.  Also, "A.*" etc will
     * be expanded by transformTargetList if they appear at SELECT top level,
     * so here we are only going to see them as function or operator inputs.
     *
     * Currently, if a catalog name is given then it must equal the current
     * database name; we check it here and then discard it.
     *----------
     */
    switch (list_length(cref->fields))
    {
        case 1:
            {
                Node       *field1 = (Node *) linitial(cref->fields);
 
                Assert(IsA(field1, String));
                colname = strVal(field1);
 
                /* Try to identify as an unqualified column */
                node = colNameToVar(pstate, colname, false, cref->location);
 
                if (node == NULL)
                {
                    /*
                     * Not known as a column of any range-table entry.
                     *
                     * Try to find the name as a relation.  Note that only
                     * relations already entered into the rangetable will be
                     * recognized.
                     *
                     * This is a hack for backwards compatibility with
                     * PostQUEL-inspired syntax.  The preferred form now is
                     * "rel.*".
                     */
                    nsitem = refnameNamespaceItem(pstate, NULL, colname,
                                                  cref->location,
                                                  &levels_up);
                    if (nsitem)
                        node = transformWholeRowRef(pstate, nsitem, levels_up,
                                                    cref->location);
                }
                break;
            }
        case 2:
            {
                Node       *field1 = (Node *) linitial(cref->fields);
                Node       *field2 = (Node *) lsecond(cref->fields);
 
                Assert(IsA(field1, String));
                relname = strVal(field1);
 
                /* Locate the referenced nsitem */
                nsitem = refnameNamespaceItem(pstate, nspname, relname,
                                              cref->location,
                                              &levels_up);
                if (nsitem == NULL)
                {
                    crerr = CRERR_NO_RTE;
                    break;
                }
 
                /* Whole-row reference? */
                if (IsA(field2, A_Star))
                {
                    node = transformWholeRowRef(pstate, nsitem, levels_up,
                                                cref->location);
                    break;
                }
 
                Assert(IsA(field2, String));
                colname = strVal(field2);
 
                /* Try to identify as a column of the nsitem */
                node = scanNSItemForColumn(pstate, nsitem, levels_up, colname,
                                           cref->location);
                if (node == NULL)
                {
                    /* Try it as a function call on the whole row */
                    node = transformWholeRowRef(pstate, nsitem, levels_up,
                                                cref->location);
                    node = ParseFuncOrColumn(pstate,
                                             list_make1(makeString(colname)),
                                             list_make1(node),
                                             pstate->p_last_srf,
                                             NULL,
                                             false,
                                             cref->location);
                }
                break;
            }
        case 3:
            {
                Node       *field1 = (Node *) linitial(cref->fields);
                Node       *field2 = (Node *) lsecond(cref->fields);
                Node       *field3 = (Node *) lthird(cref->fields);
 
                Assert(IsA(field1, String));
                nspname = strVal(field1);
                Assert(IsA(field2, String));
                relname = strVal(field2);
 
                /* Locate the referenced nsitem */
                nsitem = refnameNamespaceItem(pstate, nspname, relname,
                                              cref->location,
                                              &levels_up);
                if (nsitem == NULL)
                {
                    crerr = CRERR_NO_RTE;
                    break;
                }
 
                /* Whole-row reference? */
                if (IsA(field3, A_Star))
                {
                    node = transformWholeRowRef(pstate, nsitem, levels_up,
                                                cref->location);
                    break;
                }
 
                Assert(IsA(field3, String));
                colname = strVal(field3);
 
                /* Try to identify as a column of the nsitem */
                node = scanNSItemForColumn(pstate, nsitem, levels_up, colname,
                                           cref->location);
                if (node == NULL)
                {
                    /* Try it as a function call on the whole row */
                    node = transformWholeRowRef(pstate, nsitem, levels_up,
                                                cref->location);
                    node = ParseFuncOrColumn(pstate,
                                             list_make1(makeString(colname)),
                                             list_make1(node),
                                             pstate->p_last_srf,
                                             NULL,
                                             false,
                                             cref->location);
                }
                break;
            }
        case 4:
            {
                Node       *field1 = (Node *) linitial(cref->fields);
                Node       *field2 = (Node *) lsecond(cref->fields);
                Node       *field3 = (Node *) lthird(cref->fields);
                Node       *field4 = (Node *) lfourth(cref->fields);
                char       *catname;
 
                Assert(IsA(field1, String));
                catname = strVal(field1);
                Assert(IsA(field2, String));
                nspname = strVal(field2);
                Assert(IsA(field3, String));
                relname = strVal(field3);
 
                /*
                 * We check the catalog name and then ignore it.
                 */
                if (strcmp(catname, get_database_name(MyDatabaseId)) != 0)
                {
                    crerr = CRERR_WRONG_DB;
                    break;
                }
 
                /* Locate the referenced nsitem */
                nsitem = refnameNamespaceItem(pstate, nspname, relname,
                                              cref->location,
                                              &levels_up);
                if (nsitem == NULL)
                {
                    crerr = CRERR_NO_RTE;
                    break;
                }
 
                /* Whole-row reference? */
                if (IsA(field4, A_Star))
                {
                    node = transformWholeRowRef(pstate, nsitem, levels_up,
                                                cref->location);
                    break;
                }
 
                Assert(IsA(field4, String));
                colname = strVal(field4);
 
                /* Try to identify as a column of the nsitem */
                node = scanNSItemForColumn(pstate, nsitem, levels_up, colname,
                                           cref->location);
                if (node == NULL)
                {
                    /* Try it as a function call on the whole row */
                    node = transformWholeRowRef(pstate, nsitem, levels_up,
                                                cref->location);
                    node = ParseFuncOrColumn(pstate,
                                             list_make1(makeString(colname)),
                                             list_make1(node),
                                             pstate->p_last_srf,
                                             NULL,
                                             false,
                                             cref->location);
                }
                break;
            }
        default:
            crerr = CRERR_TOO_MANY; /* too many dotted names */
            break;
    }
 
    /*
     * Now give the PostParseColumnRefHook, if any, a chance.  We pass the
     * translation-so-far so that it can throw an error if it wishes in the
     * case that it has a conflicting interpretation of the ColumnRef. (If it
     * just translates anyway, we'll throw an error, because we can't undo
     * whatever effects the preceding steps may have had on the pstate.) If it
     * returns NULL, use the standard translation, or throw a suitable error
     * if there is none.
     */
    if (pstate->p_post_columnref_hook != NULL)
    {
        Node       *hookresult;
 
        hookresult = pstate->p_post_columnref_hook(pstate, cref, node);
        if (node == NULL)
            node = hookresult;
        else if (hookresult != NULL)
            ereport(ERROR,
                    (errcode(ERRCODE_AMBIGUOUS_COLUMN),
                     errmsg("column reference \"%s\" is ambiguous",
                            NameListToString(cref->fields)),
                     parser_errposition(pstate, cref->location)));
    }
 
    /*
     * Throw error if no translation found.
     */
    if (node == NULL)
    {
        switch (crerr)
        {
            case CRERR_NO_COLUMN:
                errorMissingColumn(pstate, relname, colname, cref->location);
                break;
            case CRERR_NO_RTE:
                errorMissingRTE(pstate, makeRangeVar(nspname, relname,
                                                     cref->location));
                break;
            case CRERR_WRONG_DB:
                ereport(ERROR,
                        (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                         errmsg("cross-database references are not implemented: %s",
                                NameListToString(cref->fields)),
                         parser_errposition(pstate, cref->location)));
                break;
            case CRERR_TOO_MANY:
                ereport(ERROR,
                        (errcode(ERRCODE_SYNTAX_ERROR),
                         errmsg("improper qualified name (too many dotted names): %s",
                                NameListToString(cref->fields)),
                         parser_errposition(pstate, cref->location)));
                break;
        }
    }
 
    return node;
}

References _, Assert(), colNameToVar(), ereport, errcode(), errmsg(), errmsg_internal(), ERROR, errorMissingColumn(), errorMissingRTE(), EXPR_KIND_ALTER_COL_TRANSFORM, EXPR_KIND_CALL_ARGUMENT, EXPR_KIND_CHECK_CONSTRAINT, EXPR_KIND_COLUMN_DEFAULT, EXPR_KIND_COPY_WHERE, EXPR_KIND_CYCLE_MARK, EXPR_KIND_DISTINCT_ON, EXPR_KIND_DOMAIN_CHECK, EXPR_KIND_EXECUTE_PARAMETER, EXPR_KIND_FILTER, EXPR_KIND_FROM_FUNCTION, EXPR_KIND_FROM_SUBSELECT, EXPR_KIND_FUNCTION_DEFAULT, EXPR_KIND_GENERATED_COLUMN, EXPR_KIND_GROUP_BY, EXPR_KIND_HAVING, EXPR_KIND_INDEX_EXPRESSION, EXPR_KIND_INDEX_PREDICATE, EXPR_KIND_INSERT_TARGET, EXPR_KIND_JOIN_ON, EXPR_KIND_JOIN_USING, EXPR_KIND_LIMIT, EXPR_KIND_MERGE_WHEN, EXPR_KIND_NONE, EXPR_KIND_OFFSET, EXPR_KIND_ORDER_BY, EXPR_KIND_OTHER, EXPR_KIND_PARTITION_BOUND, EXPR_KIND_PARTITION_EXPRESSION, EXPR_KIND_POLICY, EXPR_KIND_RETURNING, EXPR_KIND_SELECT_TARGET, EXPR_KIND_STATS_EXPRESSION, EXPR_KIND_TRIGGER_WHEN, EXPR_KIND_UPDATE_SOURCE, EXPR_KIND_UPDATE_TARGET, EXPR_KIND_VALUES, EXPR_KIND_VALUES_SINGLE, EXPR_KIND_WHERE, EXPR_KIND_WINDOW_FRAME_GROUPS, EXPR_KIND_WINDOW_FRAME_RANGE, EXPR_KIND_WINDOW_FRAME_ROWS, EXPR_KIND_WINDOW_ORDER, EXPR_KIND_WINDOW_PARTITION, ColumnRef::fields, get_database_name(), IsA, lfourth, linitial, list_length(), list_make1, ColumnRef::location, lsecond, lthird, makeRangeVar(), makeString(), MyDatabaseId, NameListToString(), ParseState::p_expr_kind, ParseState::p_last_srf, ParseState::p_post_columnref_hook, ParseState::p_pre_columnref_hook, ParseFuncOrColumn(), parser_errposition(), refnameNamespaceItem(), relname, scanNSItemForColumn(), strVal, and transformWholeRowRef().

Referenced by transformExprRecurse().

transformCurrentOfExpr()

static Node * transformCurrentOfExpr ( ParseState *  pstate, CurrentOfExpr *  cexpr  )

static

Definition at line 2524 of file parse_expr.c.

{
    /* CURRENT OF can only appear at top level of UPDATE/DELETE */
    Assert(pstate->p_target_nsitem != NULL);
    cexpr->cvarno = pstate->p_target_nsitem->p_rtindex;
 
    /*
     * Check to see if the cursor name matches a parameter of type REFCURSOR.
     * If so, replace the raw name reference with a parameter reference. (This
     * is a hack for the convenience of plpgsql.)
     */
    if (cexpr->cursor_name != NULL) /* in case already transformed */
    {
        ColumnRef  *cref = makeNode(ColumnRef);
        Node       *node = NULL;
 
        /* Build an unqualified ColumnRef with the given name */
        cref->fields = list_make1(makeString(cexpr->cursor_name));
        cref->location = -1;
 
        /* See if there is a translation available from a parser hook */
        if (pstate->p_pre_columnref_hook != NULL)
            node = pstate->p_pre_columnref_hook(pstate, cref);
        if (node == NULL && pstate->p_post_columnref_hook != NULL)
            node = pstate->p_post_columnref_hook(pstate, cref, NULL);
 
        /*
         * XXX Should we throw an error if we get a translation that isn't a
         * refcursor Param?  For now it seems best to silently ignore false
         * matches.
         */
        if (node != NULL && IsA(node, Param))
        {
            Param      *p = (Param *) node;
 
            if (p->paramkind == PARAM_EXTERN &&
                p->paramtype == REFCURSOROID)
            {
                /* Matches, so convert CURRENT OF to a param reference */
                cexpr->cursor_name = NULL;
                cexpr->cursor_param = p->paramid;
            }
        }
    }
 
    return (Node *) cexpr;
}

References Assert(), CurrentOfExpr::cursor_name, CurrentOfExpr::cursor_param, CurrentOfExpr::cvarno, ColumnRef::fields, IsA, list_make1, ColumnRef::location, makeNode, makeString(), ParseState::p_post_columnref_hook, ParseState::p_pre_columnref_hook, ParseNamespaceItem::p_rtindex, ParseState::p_target_nsitem, PARAM_EXTERN, Param::paramid, Param::paramkind, and Param::paramtype.

Referenced by transformExprRecurse().

transformExpr()

Node* transformExpr	(	ParseState *	pstate,
		Node *	expr,
		ParseExprKind	exprKind
	)

Definition at line 112 of file parse_expr.c.

{
    Node       *result;
    ParseExprKind sv_expr_kind;
 
    /* Save and restore identity of expression type we're parsing */
    Assert(exprKind != EXPR_KIND_NONE);
    sv_expr_kind = pstate->p_expr_kind;
    pstate->p_expr_kind = exprKind;
 
    result = transformExprRecurse(pstate, expr);
 
    pstate->p_expr_kind = sv_expr_kind;
 
    return result;
}

References Assert(), EXPR_KIND_NONE, ParseState::p_expr_kind, and transformExprRecurse().

Referenced by analyzeCTE(), appendJsonTableColumns(), array_subscript_transform(), cookConstraint(), cookDefault(), DoCopy(), domainAddConstraint(), EvaluateParams(), ExpandIndirectionStar(), findTargetlistEntrySQL99(), hstore_subscript_transform(), interpret_function_parameter_list(), jsonb_subscript_transform(), resolve_unique_index_expr(), transformAlterTableStmt(), transformCallStmt(), transformExpressionList(), transformFrameOffset(), transformFuncCall(), transformGroupingFunc(), transformIndexStmt(), transformJoinUsingClause(), transformJsonTable(), transformLimitClause(), transformMergeStmt(), transformOnConflictArbiter(), transformPartitionBoundValue(), transformPartitionSpec(), transformPLAssignStmt(), transformRangeFunction(), transformRangeTableFunc(), transformRangeTableSample(), transformReturnStmt(), transformStatsStmt(), transformTargetEntry(), and transformWhereClause().

transformExprRecurse()

static Node * transformExprRecurse ( ParseState *  pstate, Node *  expr  )

static

Definition at line 130 of file parse_expr.c.

{
    Node       *result;
 
    if (expr == NULL)
        return NULL;
 
    /* Guard against stack overflow due to overly complex expressions */
    check_stack_depth();
 
    switch (nodeTag(expr))
    {
        case T_ColumnRef:
            result = transformColumnRef(pstate, (ColumnRef *) expr);
            break;
 
        case T_ParamRef:
            result = transformParamRef(pstate, (ParamRef *) expr);
            break;
 
        case T_A_Const:
            result = (Node *) make_const(pstate, (A_Const *) expr);
            break;
 
        case T_A_Indirection:
            result = transformIndirection(pstate, (A_Indirection *) expr);
            break;
 
        case T_A_ArrayExpr:
            result = transformArrayExpr(pstate, (A_ArrayExpr *) expr,
                                        InvalidOid, InvalidOid, -1);
            break;
 
        case T_TypeCast:
            result = transformTypeCast(pstate, (TypeCast *) expr);
            break;
 
        case T_CollateClause:
            result = transformCollateClause(pstate, (CollateClause *) expr);
            break;
 
        case T_A_Expr:
            {
                A_Expr     *a = (A_Expr *) expr;
 
                switch (a->kind)
                {
                    case AEXPR_OP:
                        result = transformAExprOp(pstate, a);
                        break;
                    case AEXPR_OP_ANY:
                        result = transformAExprOpAny(pstate, a);
                        break;
                    case AEXPR_OP_ALL:
                        result = transformAExprOpAll(pstate, a);
                        break;
                    case AEXPR_DISTINCT:
                    case AEXPR_NOT_DISTINCT:
                        result = transformAExprDistinct(pstate, a);
                        break;
                    case AEXPR_NULLIF:
                        result = transformAExprNullIf(pstate, a);
                        break;
                    case AEXPR_IN:
                        result = transformAExprIn(pstate, a);
                        break;
                    case AEXPR_LIKE:
                    case AEXPR_ILIKE:
                    case AEXPR_SIMILAR:
                        /* we can transform these just like AEXPR_OP */
                        result = transformAExprOp(pstate, a);
                        break;
                    case AEXPR_BETWEEN:
                    case AEXPR_NOT_BETWEEN:
                    case AEXPR_BETWEEN_SYM:
                    case AEXPR_NOT_BETWEEN_SYM:
                        result = transformAExprBetween(pstate, a);
                        break;
                    default:
                        elog(ERROR, "unrecognized A_Expr kind: %d", a->kind);
                        result = NULL;  /* keep compiler quiet */
                        break;
                }
                break;
            }
 
        case T_BoolExpr:
            result = transformBoolExpr(pstate, (BoolExpr *) expr);
            break;
 
        case T_FuncCall:
            result = transformFuncCall(pstate, (FuncCall *) expr);
            break;
 
        case T_MultiAssignRef:
            result = transformMultiAssignRef(pstate, (MultiAssignRef *) expr);
            break;
 
        case T_GroupingFunc:
            result = transformGroupingFunc(pstate, (GroupingFunc *) expr);
            break;
 
        case T_NamedArgExpr:
            {
                NamedArgExpr *na = (NamedArgExpr *) expr;
 
                na->arg = (Expr *) transformExprRecurse(pstate, (Node *) na->arg);
                result = expr;
                break;
            }
 
        case T_SubLink:
            result = transformSubLink(pstate, (SubLink *) expr);
            break;
 
        case T_CaseExpr:
            result = transformCaseExpr(pstate, (CaseExpr *) expr);
            break;
 
        case T_RowExpr:
            result = transformRowExpr(pstate, (RowExpr *) expr, false);
            break;
 
        case T_CoalesceExpr:
            result = transformCoalesceExpr(pstate, (CoalesceExpr *) expr);
            break;
 
        case T_MinMaxExpr:
            result = transformMinMaxExpr(pstate, (MinMaxExpr *) expr);
            break;
 
        case T_SQLValueFunction:
            result = transformSQLValueFunction(pstate,
                                               (SQLValueFunction *) expr);
            break;
 
        case T_XmlExpr:
            result = transformXmlExpr(pstate, (XmlExpr *) expr);
            break;
 
        case T_XmlSerialize:
            result = transformXmlSerialize(pstate, (XmlSerialize *) expr);
            break;
 
        case T_NullTest:
            {
                NullTest   *n = (NullTest *) expr;
 
                n->arg = (Expr *) transformExprRecurse(pstate, (Node *) n->arg);
                /* the argument can be any type, so don't coerce it */
                n->argisrow = type_is_rowtype(exprType((Node *) n->arg));
                result = expr;
                break;
            }
 
        case T_BooleanTest:
            result = transformBooleanTest(pstate, (BooleanTest *) expr);
            break;
 
        case T_CurrentOfExpr:
            result = transformCurrentOfExpr(pstate, (CurrentOfExpr *) expr);
            break;
 
            /*
             * In all places where DEFAULT is legal, the caller should have
             * processed it rather than passing it to transformExpr().
             */
        case T_SetToDefault:
            ereport(ERROR,
                    (errcode(ERRCODE_SYNTAX_ERROR),
                     errmsg("DEFAULT is not allowed in this context"),
                     parser_errposition(pstate,
                                        ((SetToDefault *) expr)->location)));
            break;
 
            /*
             * CaseTestExpr doesn't require any processing; it is only
             * injected into parse trees in a fully-formed state.
             *
             * Ordinarily we should not see a Var here, but it is convenient
             * for transformJoinUsingClause() to create untransformed operator
             * trees containing already-transformed Vars.  The best
             * alternative would be to deconstruct and reconstruct column
             * references, which seems expensively pointless.  So allow it.
             */
        case T_CaseTestExpr:
        case T_Var:
            {
                result = (Node *) expr;
                break;
            }
 
        case T_JsonObjectConstructor:
            result = transformJsonObjectConstructor(pstate, (JsonObjectConstructor *) expr);
            break;
 
        case T_JsonArrayConstructor:
            result = transformJsonArrayConstructor(pstate, (JsonArrayConstructor *) expr);
            break;
 
        case T_JsonArrayQueryConstructor:
            result = transformJsonArrayQueryConstructor(pstate, (JsonArrayQueryConstructor *) expr);
            break;
 
        case T_JsonObjectAgg:
            result = transformJsonObjectAgg(pstate, (JsonObjectAgg *) expr);
            break;
 
        case T_JsonArrayAgg:
            result = transformJsonArrayAgg(pstate, (JsonArrayAgg *) expr);
            break;
 
        case T_JsonIsPredicate:
            result = transformJsonIsPredicate(pstate, (JsonIsPredicate *) expr);
            break;
 
        case T_JsonFuncExpr:
            result = transformJsonFuncExpr(pstate, (JsonFuncExpr *) expr);
            break;
 
        case T_JsonValueExpr:
            result = transformJsonValueExpr(pstate, (JsonValueExpr *) expr);
            break;
 
        case T_JsonParseExpr:
            result = transformJsonParseExpr(pstate, (JsonParseExpr *) expr);
            break;
 
        case T_JsonScalarExpr:
            result = transformJsonScalarExpr(pstate, (JsonScalarExpr *) expr);
            break;
 
        case T_JsonSerializeExpr:
            result = transformJsonSerializeExpr(pstate, (JsonSerializeExpr *) expr);
            break;
 
        default:
            /* should not reach here */
            elog(ERROR, "unrecognized node type: %d", (int) nodeTag(expr));
            result = NULL;      /* keep compiler quiet */
            break;
    }
 
    return result;
}

References a, AEXPR_BETWEEN, AEXPR_BETWEEN_SYM, AEXPR_DISTINCT, AEXPR_ILIKE, AEXPR_IN, AEXPR_LIKE, AEXPR_NOT_BETWEEN, AEXPR_NOT_BETWEEN_SYM, AEXPR_NOT_DISTINCT, AEXPR_NULLIF, AEXPR_OP, AEXPR_OP_ALL, AEXPR_OP_ANY, AEXPR_SIMILAR, NamedArgExpr::arg, NullTest::arg, NullTest::argisrow, check_stack_depth(), elog, ereport, errcode(), errmsg(), ERROR, exprType(), InvalidOid, make_const(), nodeTag, parser_errposition(), T_A_ArrayExpr, T_A_Const, T_A_Expr, T_A_Indirection, T_BooleanTest, T_BoolExpr, T_CaseExpr, T_CaseTestExpr, T_CoalesceExpr, T_CollateClause, T_ColumnRef, T_CurrentOfExpr, T_FuncCall, T_GroupingFunc, T_JsonArrayAgg, T_JsonArrayConstructor, T_JsonArrayQueryConstructor, T_JsonFuncExpr, T_JsonIsPredicate, T_JsonObjectAgg, T_JsonObjectConstructor, T_JsonParseExpr, T_JsonScalarExpr, T_JsonSerializeExpr, T_JsonValueExpr, T_MinMaxExpr, T_MultiAssignRef, T_NamedArgExpr, T_NullTest, T_ParamRef, T_RowExpr, T_SetToDefault, T_SQLValueFunction, T_SubLink, T_TypeCast, T_Var, T_XmlExpr, T_XmlSerialize, transformAExprBetween(), transformAExprDistinct(), transformAExprIn(), transformAExprNullIf(), transformAExprOp(), transformAExprOpAll(), transformAExprOpAny(), transformArrayExpr(), transformBooleanTest(), transformBoolExpr(), transformCaseExpr(), transformCoalesceExpr(), transformCollateClause(), transformColumnRef(), transformCurrentOfExpr(), transformFuncCall(), transformGroupingFunc(), transformIndirection(), transformJsonArrayAgg(), transformJsonArrayConstructor(), transformJsonArrayQueryConstructor(), transformJsonFuncExpr(), transformJsonIsPredicate(), transformJsonObjectAgg(), transformJsonObjectConstructor(), transformJsonParseExpr(), transformJsonScalarExpr(), transformJsonSerializeExpr(), transformJsonValueExpr(), transformMinMaxExpr(), transformMultiAssignRef(), transformParamRef(), transformRowExpr(), transformSQLValueFunction(), transformSubLink(), transformTypeCast(), transformXmlExpr(), transformXmlSerialize(), and type_is_rowtype().

Referenced by make_nulltest_from_distinct(), transformAExprBetween(), transformAExprDistinct(), transformAExprIn(), transformAExprNullIf(), transformAExprOp(), transformAExprOpAll(), transformAExprOpAny(), transformArrayExpr(), transformBooleanTest(), transformBoolExpr(), transformCaseExpr(), transformCoalesceExpr(), transformCollateClause(), transformExpr(), transformFuncCall(), transformIndirection(), transformJsonArrayQueryConstructor(), transformJsonBehavior(), transformJsonExprCommon(), transformJsonObjectAgg(), transformJsonObjectConstructor(), transformJsonParseArg(), transformJsonScalarExpr(), transformJsonValueExprExt(), transformMinMaxExpr(), transformMultiAssignRef(), transformSubLink(), transformTypeCast(), transformXmlExpr(), and transformXmlSerialize().

transformFuncCall()

static Node * transformFuncCall ( ParseState *  pstate, FuncCall *  fn  )

static

Definition at line 1413 of file parse_expr.c.

{
    Node       *last_srf = pstate->p_last_srf;
    List       *targs;
    ListCell   *args;
 
    /* Transform the list of arguments ... */
    targs = NIL;
    foreach(args, fn->args)
    {
        targs = lappend(targs, transformExprRecurse(pstate,
                                                    (Node *) lfirst(args)));
    }
 
    /*
     * When WITHIN GROUP is used, we treat its ORDER BY expressions as
     * additional arguments to the function, for purposes of function lookup
     * and argument type coercion.  So, transform each such expression and add
     * them to the targs list.  We don't explicitly mark where each argument
     * came from, but ParseFuncOrColumn can tell what's what by reference to
     * list_length(fn->agg_order).
     */
    if (fn->agg_within_group)
    {
        Assert(fn->agg_order != NIL);
        foreach(args, fn->agg_order)
        {
            SortBy     *arg = (SortBy *) lfirst(args);
 
            targs = lappend(targs, transformExpr(pstate, arg->node,
                                                 EXPR_KIND_ORDER_BY));
        }
    }
 
    /* ... and hand off to ParseFuncOrColumn */
    return ParseFuncOrColumn(pstate,
                             fn->funcname,
                             targs,
                             last_srf,
                             fn,
                             false,
                             fn->location);
}

References arg, generate_unaccent_rules::args, Assert(), EXPR_KIND_ORDER_BY, fn(), lappend(), lfirst, NIL, ParseState::p_last_srf, ParseFuncOrColumn(), transformExpr(), and transformExprRecurse().

Referenced by transformExprRecurse().

transformIndirection()

static Node * transformIndirection ( ParseState *  pstate, A_Indirection *  ind  )

static

Definition at line 429 of file parse_expr.c.

{
    Node       *last_srf = pstate->p_last_srf;
    Node       *result = transformExprRecurse(pstate, ind->arg);
    List       *subscripts = NIL;
    int         location = exprLocation(result);
    ListCell   *i;
 
    /*
     * We have to split any field-selection operations apart from
     * subscripting.  Adjacent A_Indices nodes have to be treated as a single
     * multidimensional subscript operation.
     */
    foreach(i, ind->indirection)
    {
        Node       *n = lfirst(i);
 
        if (IsA(n, A_Indices))
            subscripts = lappend(subscripts, n);
        else if (IsA(n, A_Star))
        {
            ereport(ERROR,
                    (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                     errmsg("row expansion via \"*\" is not supported here"),
                     parser_errposition(pstate, location)));
        }
        else
        {
            Node       *newresult;
 
            Assert(IsA(n, String));
 
            /* process subscripts before this field selection */
            if (subscripts)
                result = (Node *) transformContainerSubscripts(pstate,
                                                               result,
                                                               exprType(result),
                                                               exprTypmod(result),
                                                               subscripts,
                                                               false);
            subscripts = NIL;
 
            newresult = ParseFuncOrColumn(pstate,
                                          list_make1(n),
                                          list_make1(result),
                                          last_srf,
                                          NULL,
                                          false,
                                          location);
            if (newresult == NULL)
                unknown_attribute(pstate, result, strVal(n), location);
            result = newresult;
        }
    }
    /* process trailing subscripts, if any */
    if (subscripts)
        result = (Node *) transformContainerSubscripts(pstate,
                                                       result,
                                                       exprType(result),
                                                       exprTypmod(result),
                                                       subscripts,
                                                       false);
 
    return result;
}

References Assert(), ereport, errcode(), errmsg(), ERROR, exprLocation(), exprType(), exprTypmod(), i, IsA, lappend(), lfirst, list_make1, NIL, ParseState::p_last_srf, ParseFuncOrColumn(), parser_errposition(), strVal, transformContainerSubscripts(), transformExprRecurse(), and unknown_attribute().

Referenced by transformExprRecurse().

transformJsonAggConstructor()

static Node* transformJsonAggConstructor ( ParseState *  pstate, JsonAggConstructor *  agg_ctor, JsonReturning *  returning, List *  args, const char *  aggfn, Oid  aggtype, JsonConstructorType  ctor_type, bool  unique, bool  absent_on_null  )

static

Definition at line 3761 of file parse_expr.c.

{
    Oid         aggfnoid;
    Node       *node;
    Expr       *aggfilter = agg_ctor->agg_filter ? (Expr *)
    transformWhereClause(pstate, agg_ctor->agg_filter,
                         EXPR_KIND_FILTER, "FILTER") : NULL;
 
    aggfnoid = DatumGetInt32(DirectFunctionCall1(regprocin,
                                                 CStringGetDatum(aggfn)));
 
    if (agg_ctor->over)
    {
        /* window function */
        WindowFunc *wfunc = makeNode(WindowFunc);
 
        wfunc->winfnoid = aggfnoid;
        wfunc->wintype = aggtype;
        /* wincollid and inputcollid will be set by parse_collate.c */
        wfunc->args = args;
        /* winref will be set by transformWindowFuncCall */
        wfunc->winstar = false;
        wfunc->winagg = true;
        wfunc->aggfilter = aggfilter;
        wfunc->location = agg_ctor->location;
 
        /*
         * ordered aggs not allowed in windows yet
         */
        if (agg_ctor->agg_order != NIL)
            ereport(ERROR,
                    (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                     errmsg("aggregate ORDER BY is not implemented for window functions"),
                     parser_errposition(pstate, agg_ctor->location)));
 
        /* parse_agg.c does additional window-func-specific processing */
        transformWindowFuncCall(pstate, wfunc, agg_ctor->over);
 
        node = (Node *) wfunc;
    }
    else
    {
        Aggref     *aggref = makeNode(Aggref);
 
        aggref->aggfnoid = aggfnoid;
        aggref->aggtype = aggtype;
 
        /* aggcollid and inputcollid will be set by parse_collate.c */
        aggref->aggtranstype = InvalidOid;  /* will be set by planner */
        /* aggargtypes will be set by transformAggregateCall */
        /* aggdirectargs and args will be set by transformAggregateCall */
        /* aggorder and aggdistinct will be set by transformAggregateCall */
        aggref->aggfilter = aggfilter;
        aggref->aggstar = false;
        aggref->aggvariadic = false;
        aggref->aggkind = AGGKIND_NORMAL;
        /* agglevelsup will be set by transformAggregateCall */
        aggref->aggsplit = AGGSPLIT_SIMPLE; /* planner might change this */
        aggref->location = agg_ctor->location;
 
        transformAggregateCall(pstate, aggref, args, agg_ctor->agg_order, false);
 
        node = (Node *) aggref;
    }
 
    return makeJsonConstructorExpr(pstate, ctor_type, NIL, (Expr *) node,
                                   returning, unique, absent_on_null,
                                   agg_ctor->location);
}

References JsonAggConstructor::agg_filter, JsonAggConstructor::agg_order, Aggref::aggfilter, WindowFunc::aggfilter, Aggref::aggfnoid, Aggref::aggkind, Aggref::aggsplit, AGGSPLIT_SIMPLE, Aggref::aggstar, Aggref::aggtranstype, Aggref::aggtype, Aggref::aggvariadic, generate_unaccent_rules::args, WindowFunc::args, CStringGetDatum, DatumGetInt32, DirectFunctionCall1, ereport, errcode(), errmsg(), ERROR, EXPR_KIND_FILTER, InvalidOid, JsonAggConstructor::location, Aggref::location, WindowFunc::location, makeJsonConstructorExpr(), makeNode, NIL, JsonAggConstructor::over, parser_errposition(), regprocin(), transformAggregateCall(), transformWhereClause(), transformWindowFuncCall(), WindowFunc::winagg, WindowFunc::winfnoid, WindowFunc::winstar, and WindowFunc::wintype.

Referenced by transformJsonArrayAgg(), and transformJsonObjectAgg().

transformJsonArrayAgg()

static Node * transformJsonArrayAgg ( ParseState *  pstate, JsonArrayAgg *  agg  )

static

Definition at line 3903 of file parse_expr.c.

{
    JsonReturning *returning;
    Node       *arg;
    const char *aggfnname;
    Oid         aggtype;
 
    arg = transformJsonValueExprDefault(pstate, agg->arg);
 
    returning = transformJsonConstructorOutput(pstate, agg->constructor->output,
                                               list_make1(arg));
 
    if (returning->format->format_type == JS_FORMAT_JSONB)
    {
        aggfnname = agg->absent_on_null ?
            "pg_catalog.jsonb_agg_strict" : "pg_catalog.jsonb_agg";
        aggtype = JSONBOID;
    }
    else
    {
        aggfnname = agg->absent_on_null ?
            "pg_catalog.json_agg_strict" : "pg_catalog.json_agg";
        aggtype = JSONOID;
    }
 
    return transformJsonAggConstructor(pstate, agg->constructor, returning,
                                       list_make1(arg), aggfnname, aggtype,
                                       JSCTOR_JSON_ARRAYAGG,
                                       false, agg->absent_on_null);
}

References JsonArrayAgg::absent_on_null, arg, JsonArrayAgg::arg, JsonArrayAgg::constructor, JsonReturning::format, JsonFormat::format_type, JS_FORMAT_JSONB, JSCTOR_JSON_ARRAYAGG, list_make1, JsonAggConstructor::output, transformJsonAggConstructor(), transformJsonConstructorOutput(), and transformJsonValueExprDefault().

Referenced by transformExprRecurse().

transformJsonArrayConstructor()

static Node * transformJsonArrayConstructor ( ParseState *  pstate, JsonArrayConstructor *  ctor  )

static

Definition at line 3944 of file parse_expr.c.

{
    JsonReturning *returning;
    List       *args = NIL;
 
    /* transform element expressions, if any */
    if (ctor->exprs)
    {
        ListCell   *lc;
 
        /* transform and append element arguments */
        foreach(lc, ctor->exprs)
        {
            JsonValueExpr *jsval = castNode(JsonValueExpr, lfirst(lc));
            Node       *val = transformJsonValueExprDefault(pstate, jsval);
 
            args = lappend(args, val);
        }
    }
 
    returning = transformJsonConstructorOutput(pstate, ctor->output, args);
 
    return makeJsonConstructorExpr(pstate, JSCTOR_JSON_ARRAY, args, NULL,
                                   returning, false, ctor->absent_on_null,
                                   ctor->location);
}

References JsonArrayConstructor::absent_on_null, generate_unaccent_rules::args, castNode, JsonArrayConstructor::exprs, JSCTOR_JSON_ARRAY, lappend(), lfirst, JsonArrayConstructor::location, makeJsonConstructorExpr(), NIL, JsonArrayConstructor::output, transformJsonConstructorOutput(), transformJsonValueExprDefault(), and val.

Referenced by transformExprRecurse().

transformJsonArrayQueryConstructor()

static Node * transformJsonArrayQueryConstructor ( ParseState *  pstate, JsonArrayQueryConstructor *  ctor  )

static

Definition at line 3695 of file parse_expr.c.

{
    SubLink    *sublink = makeNode(SubLink);
    SelectStmt *select = makeNode(SelectStmt);
    RangeSubselect *range = makeNode(RangeSubselect);
    Alias      *alias = makeNode(Alias);
    ResTarget  *target = makeNode(ResTarget);
    JsonArrayAgg *agg = makeNode(JsonArrayAgg);
    ColumnRef  *colref = makeNode(ColumnRef);
    Query      *query;
    ParseState *qpstate;
 
    /* Transform query only for counting target list entries. */
    qpstate = make_parsestate(pstate);
 
    query = transformStmt(qpstate, ctor->query);
 
    if (count_nonjunk_tlist_entries(query->targetList) != 1)
        ereport(ERROR,
                (errcode(ERRCODE_SYNTAX_ERROR),
                 errmsg("subquery must return only one column"),
                 parser_errposition(pstate, ctor->location)));
 
    free_parsestate(qpstate);
 
    colref->fields = list_make2(makeString(pstrdup("q")),
                                makeString(pstrdup("a")));
    colref->location = ctor->location;
 
    agg->arg = makeJsonValueExpr((Expr *) colref, ctor->format);
    agg->absent_on_null = ctor->absent_on_null;
    agg->constructor = makeNode(JsonAggConstructor);
    agg->constructor->agg_order = NIL;
    agg->constructor->output = ctor->output;
    agg->constructor->location = ctor->location;
 
    target->name = NULL;
    target->indirection = NIL;
    target->val = (Node *) agg;
    target->location = ctor->location;
 
    alias->aliasname = pstrdup("q");
    alias->colnames = list_make1(makeString(pstrdup("a")));
 
    range->lateral = false;
    range->subquery = ctor->query;
    range->alias = alias;
 
    select->targetList = list_make1(target);
    select->fromClause = list_make1(range);
 
    sublink->subLinkType = EXPR_SUBLINK;
    sublink->subLinkId = 0;
    sublink->testexpr = NULL;
    sublink->operName = NIL;
    sublink->subselect = (Node *) select;
    sublink->location = ctor->location;
 
    return transformExprRecurse(pstate, (Node *) sublink);
}

References JsonArrayQueryConstructor::absent_on_null, JsonArrayAgg::absent_on_null, JsonAggConstructor::agg_order, Alias::aliasname, JsonArrayAgg::arg, Alias::colnames, JsonArrayAgg::constructor, count_nonjunk_tlist_entries(), ereport, errcode(), errmsg(), ERROR, EXPR_SUBLINK, ColumnRef::fields, JsonArrayQueryConstructor::format, free_parsestate(), ResTarget::indirection, list_make1, list_make2, ColumnRef::location, ResTarget::location, JsonArrayQueryConstructor::location, JsonAggConstructor::location, SubLink::location, make_parsestate(), makeJsonValueExpr(), makeNode, makeString(), ResTarget::name, NIL, SubLink::operName, JsonArrayQueryConstructor::output, JsonAggConstructor::output, parser_errposition(), pstrdup(), JsonArrayQueryConstructor::query, range(), select, SubLink::subLinkId, SubLink::subLinkType, SubLink::subselect, Query::targetList, SubLink::testexpr, transformExprRecurse(), transformStmt(), and ResTarget::val.

Referenced by transformExprRecurse().

transformJsonBehavior()

static JsonBehavior* transformJsonBehavior ( ParseState *  pstate, JsonBehavior *  behavior, JsonBehaviorType  default_behavior  )

static

Definition at line 4071 of file parse_expr.c.

{
    JsonBehaviorType behavior_type = default_behavior;
    Node       *default_expr = NULL;
 
    if (behavior)
    {
        behavior_type = behavior->btype;
        if (behavior_type == JSON_BEHAVIOR_DEFAULT)
            default_expr = transformExprRecurse(pstate, behavior->default_expr);
    }
    return makeJsonBehavior(behavior_type, default_expr);
}

References JsonBehavior::btype, JsonBehavior::default_expr, JSON_BEHAVIOR_DEFAULT, makeJsonBehavior(), and transformExprRecurse().

Referenced by transformJsonExprCommon().

transformJsonConstructorOutput()

static JsonReturning* transformJsonConstructorOutput ( ParseState *  pstate, JsonOutput *  output, List *  args  )

static

Definition at line 3515 of file parse_expr.c.

{
    JsonReturning *returning = transformJsonOutput(pstate, output, true);
 
    if (!OidIsValid(returning->typid))
    {
        ListCell   *lc;
        bool        have_jsonb = false;
 
        foreach(lc, args)
        {
            Node       *expr = lfirst(lc);
            Oid         typid = exprType(expr);
 
            have_jsonb |= typid == JSONBOID;
 
            if (have_jsonb)
                break;
        }
 
        if (have_jsonb)
        {
            returning->typid = JSONBOID;
            returning->format->format_type = JS_FORMAT_JSONB;
        }
        else
        {
            /* XXX TEXT is default by the standard, but we return JSON */
            returning->typid = JSONOID;
            returning->format->format_type = JS_FORMAT_JSON;
        }
 
        returning->typmod = -1;
    }
 
    return returning;
}

References generate_unaccent_rules::args, exprType(), JsonReturning::format, JsonFormat::format_type, JS_FORMAT_JSON, JS_FORMAT_JSONB, lfirst, OidIsValid, output(), transformJsonOutput(), JsonReturning::typid, and JsonReturning::typmod.

Referenced by transformJsonArrayAgg(), transformJsonArrayConstructor(), transformJsonObjectAgg(), and transformJsonObjectConstructor().

transformJsonConstructorRet()

static JsonReturning* transformJsonConstructorRet ( ParseState *  pstate, JsonOutput *  output, const char *  fname  )

static

Definition at line 4476 of file parse_expr.c.

{
    JsonReturning *returning;
 
    if (output)
    {
        returning = transformJsonOutput(pstate, output, false);
 
        Assert(OidIsValid(returning->typid));
 
        if (returning->typid != JSONOID && returning->typid != JSONBOID)
            ereport(ERROR,
                    (errcode(ERRCODE_DATATYPE_MISMATCH),
                     errmsg("cannot use RETURNING type %s in %s",
                            format_type_be(returning->typid), fname),
                     parser_errposition(pstate, output->typeName->location)));
    }
    else
    {
        Oid         targettype = JSONOID;
        JsonFormatType format = JS_FORMAT_JSON;
 
        returning = makeNode(JsonReturning);
        returning->format = makeJsonFormat(format, JS_ENC_DEFAULT, -1);
        returning->typid = targettype;
        returning->typmod = -1;
    }
 
    return returning;
}

References Assert(), ereport, errcode(), errmsg(), ERROR, format, JsonReturning::format, format_type_be(), JS_ENC_DEFAULT, JS_FORMAT_JSON, makeJsonFormat(), makeNode, OidIsValid, output(), parser_errposition(), transformJsonOutput(), JsonReturning::typid, and JsonReturning::typmod.

Referenced by transformJsonParseExpr(), and transformJsonScalarExpr().

transformJsonExprCommon()

static JsonExpr* transformJsonExprCommon ( ParseState *  pstate, JsonFuncExpr *  func  )

static

Definition at line 4091 of file parse_expr.c.

{
    JsonExpr   *jsexpr = makeNode(JsonExpr);
    Node       *pathspec;
    JsonFormatType format;
 
    if (func->common->pathname && func->op != JSON_TABLE_OP)
        ereport(ERROR,
                (errcode(ERRCODE_SYNTAX_ERROR),
                 errmsg("JSON_TABLE path name is not allowed here"),
                 parser_errposition(pstate, func->location)));
 
    jsexpr->location = func->location;
    jsexpr->op = func->op;
    jsexpr->formatted_expr = transformJsonValueExpr(pstate, func->common->expr);
 
    assign_expr_collations(pstate, jsexpr->formatted_expr);
 
    /* format is determined by context item type */
    format = exprType(jsexpr->formatted_expr) == JSONBOID ? JS_FORMAT_JSONB : JS_FORMAT_JSON;
 
    jsexpr->result_coercion = NULL;
    jsexpr->omit_quotes = false;
 
    jsexpr->format = func->common->expr->format;
 
    pathspec = transformExprRecurse(pstate, func->common->pathspec);
 
    jsexpr->path_spec =
        coerce_to_target_type(pstate, pathspec, exprType(pathspec),
                              JSONPATHOID, -1,
                              COERCION_EXPLICIT, COERCE_IMPLICIT_CAST,
                              exprLocation(pathspec));
    if (!jsexpr->path_spec)
        ereport(ERROR,
                (errcode(ERRCODE_DATATYPE_MISMATCH),
                 errmsg("JSON path expression must be type %s, not type %s",
                        "jsonpath", format_type_be(exprType(pathspec))),
                 parser_errposition(pstate, exprLocation(pathspec))));
 
    /* transform and coerce to json[b] passing arguments */
    transformJsonPassingArgs(pstate, format, func->common->passing,
                             &jsexpr->passing_values, &jsexpr->passing_names);
 
    if (func->op != JSON_EXISTS_OP && func->op != JSON_TABLE_OP)
        jsexpr->on_empty = transformJsonBehavior(pstate, func->on_empty,
                                                 JSON_BEHAVIOR_NULL);
 
    if (func->op == JSON_EXISTS_OP)
        jsexpr->on_error = transformJsonBehavior(pstate, func->on_error,
                                                 JSON_BEHAVIOR_FALSE);
    else if (func->op == JSON_TABLE_OP)
        jsexpr->on_error = transformJsonBehavior(pstate, func->on_error,
                                                 JSON_BEHAVIOR_EMPTY);
    else
        jsexpr->on_error = transformJsonBehavior(pstate, func->on_error,
                                                 JSON_BEHAVIOR_NULL);
 
    return jsexpr;
}

References assign_expr_collations(), COERCE_IMPLICIT_CAST, coerce_to_target_type(), COERCION_EXPLICIT, JsonFuncExpr::common, ereport, errcode(), errmsg(), ERROR, JsonCommon::expr, exprLocation(), exprType(), format, JsonValueExpr::format, JsonExpr::format, format_type_be(), JsonExpr::formatted_expr, JS_FORMAT_JSON, JS_FORMAT_JSONB, JSON_BEHAVIOR_EMPTY, JSON_BEHAVIOR_FALSE, JSON_BEHAVIOR_NULL, JSON_EXISTS_OP, JSON_TABLE_OP, JsonFuncExpr::location, JsonExpr::location, makeNode, JsonExpr::omit_quotes, JsonFuncExpr::on_empty, JsonExpr::on_empty, JsonFuncExpr::on_error, JsonExpr::on_error, JsonFuncExpr::op, JsonExpr::op, parser_errposition(), JsonCommon::passing, JsonExpr::passing_names, JsonExpr::passing_values, JsonExpr::path_spec, JsonCommon::pathname, JsonCommon::pathspec, JsonExpr::result_coercion, transformExprRecurse(), transformJsonBehavior(), transformJsonPassingArgs(), and transformJsonValueExpr().

Referenced by transformJsonFuncExpr().

transformJsonFuncExpr()

static Node * transformJsonFuncExpr ( ParseState *  pstate, JsonFuncExpr *  p  )

static

Definition at line 4357 of file parse_expr.c.

{
    JsonExpr   *jsexpr = transformJsonExprCommon(pstate, func);
    const char *func_name = NULL;
    Node       *contextItemExpr = jsexpr->formatted_expr;
 
    switch (func->op)
    {
        case JSON_VALUE_OP:
            func_name = "JSON_VALUE";
 
            transformJsonFuncExprOutput(pstate, func, jsexpr);
 
            jsexpr->returning->format->format_type = JS_FORMAT_DEFAULT;
            jsexpr->returning->format->encoding = JS_ENC_DEFAULT;
 
            jsexpr->on_empty->default_expr =
                coerceDefaultJsonExpr(pstate, jsexpr,
                                      jsexpr->on_empty->default_expr);
 
            jsexpr->on_error->default_expr =
                coerceDefaultJsonExpr(pstate, jsexpr,
                                      jsexpr->on_error->default_expr);
 
            jsexpr->coercions = makeNode(JsonItemCoercions);
            initJsonItemCoercions(pstate, jsexpr->coercions, jsexpr->returning,
                                  exprType(contextItemExpr));
 
            break;
 
        case JSON_QUERY_OP:
            func_name = "JSON_QUERY";
 
            transformJsonFuncExprOutput(pstate, func, jsexpr);
 
            jsexpr->on_empty->default_expr =
                coerceDefaultJsonExpr(pstate, jsexpr,
                                      jsexpr->on_empty->default_expr);
 
            jsexpr->on_error->default_expr =
                coerceDefaultJsonExpr(pstate, jsexpr,
                                      jsexpr->on_error->default_expr);
 
            jsexpr->wrapper = func->wrapper;
            jsexpr->omit_quotes = func->omit_quotes;
 
            break;
 
        case JSON_EXISTS_OP:
            func_name = "JSON_EXISTS";
 
            jsexpr->returning = transformJsonOutput(pstate, func->output, false);
 
            jsexpr->returning->format->format_type = JS_FORMAT_DEFAULT;
            jsexpr->returning->format->encoding = JS_ENC_DEFAULT;
 
            if (!OidIsValid(jsexpr->returning->typid))
            {
                jsexpr->returning->typid = BOOLOID;
                jsexpr->returning->typmod = -1;
            }
            else if (jsexpr->returning->typid != BOOLOID)
            {
                CaseTestExpr *placeholder = makeNode(CaseTestExpr);
                int         location = exprLocation((Node *) jsexpr);
 
                placeholder->typeId = BOOLOID;
                placeholder->typeMod = -1;
                placeholder->collation = InvalidOid;
 
                jsexpr->result_coercion = makeNode(JsonCoercion);
                jsexpr->result_coercion->expr =
                    coerce_to_target_type(pstate, (Node *) placeholder, BOOLOID,
                                          jsexpr->returning->typid,
                                          jsexpr->returning->typmod,
                                          COERCION_EXPLICIT,
                                          COERCE_IMPLICIT_CAST,
                                          location);
 
                if (!jsexpr->result_coercion->expr)
                    ereport(ERROR,
                            (errcode(ERRCODE_CANNOT_COERCE),
                             errmsg("cannot cast type %s to %s",
                                    format_type_be(BOOLOID),
                                    format_type_be(jsexpr->returning->typid)),
                             parser_coercion_errposition(pstate, location, (Node *) jsexpr)));
 
                if (jsexpr->result_coercion->expr == (Node *) placeholder)
                    jsexpr->result_coercion->expr = NULL;
            }
            break;
 
        case JSON_TABLE_OP:
            jsexpr->returning = makeNode(JsonReturning);
            jsexpr->returning->format = makeJsonFormat(JS_FORMAT_DEFAULT, JS_ENC_DEFAULT, -1);
            jsexpr->returning->typid = exprType(contextItemExpr);
            jsexpr->returning->typmod = -1;
 
            if (jsexpr->returning->typid != JSONBOID)
                ereport(ERROR,
                        (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                         errmsg("JSON_TABLE() is not yet implemented for the json type"),
                         errhint("Try casting the argument to jsonb"),
                         parser_errposition(pstate, func->location)));
 
            break;
    }
 
    if (exprType(contextItemExpr) != JSONBOID)
        ereport(ERROR,
                (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                 errmsg("%s() is not yet implemented for the json type", func_name),
                 errhint("Try casting the argument to jsonb"),
                 parser_errposition(pstate, func->location)));
 
    return (Node *) jsexpr;
}

References COERCE_IMPLICIT_CAST, coerce_to_target_type(), coerceDefaultJsonExpr(), COERCION_EXPLICIT, JsonExpr::coercions, CaseTestExpr::collation, JsonBehavior::default_expr, JsonFormat::encoding, ereport, errcode(), errhint(), errmsg(), ERROR, exprLocation(), exprType(), JsonReturning::format, JsonFormat::format_type, format_type_be(), JsonExpr::formatted_expr, initJsonItemCoercions(), InvalidOid, JS_ENC_DEFAULT, JS_FORMAT_DEFAULT, JSON_EXISTS_OP, JSON_QUERY_OP, JSON_TABLE_OP, JSON_VALUE_OP, JsonFuncExpr::location, makeJsonFormat(), makeNode, OidIsValid, JsonFuncExpr::omit_quotes, JsonExpr::omit_quotes, JsonExpr::on_empty, JsonExpr::on_error, JsonFuncExpr::op, JsonFuncExpr::output, parser_coercion_errposition(), parser_errposition(), JsonExpr::returning, transformJsonExprCommon(), transformJsonFuncExprOutput(), transformJsonOutput(), CaseTestExpr::typeId, CaseTestExpr::typeMod, JsonReturning::typid, JsonReturning::typmod, JsonFuncExpr::wrapper, and JsonExpr::wrapper.

Referenced by transformExprRecurse().

transformJsonFuncExprOutput()

static void transformJsonFuncExprOutput ( ParseState *  pstate, JsonFuncExpr *  func, JsonExpr *  jsexpr  )

static

Definition at line 4211 of file parse_expr.c.

{
    Node       *expr = jsexpr->formatted_expr;
 
    jsexpr->returning = transformJsonOutput(pstate, func->output, false);
 
    /* JSON_VALUE returns text by default */
    if (func->op == JSON_VALUE_OP && !OidIsValid(jsexpr->returning->typid))
    {
        jsexpr->returning->typid = TEXTOID;
        jsexpr->returning->typmod = -1;
    }
 
    if (OidIsValid(jsexpr->returning->typid))
    {
        JsonReturning ret;
 
        if (func->op == JSON_VALUE_OP &&
            jsexpr->returning->typid != JSONOID &&
            jsexpr->returning->typid != JSONBOID)
        {
            /* Forced coercion via I/O for JSON_VALUE for non-JSON types */
            jsexpr->result_coercion = makeNode(JsonCoercion);
            jsexpr->result_coercion->expr = NULL;
            jsexpr->result_coercion->via_io = true;
            return;
        }
 
        assignDefaultJsonReturningType(jsexpr->formatted_expr, jsexpr->format, &ret);
 
        if (ret.typid != jsexpr->returning->typid ||
            ret.typmod != jsexpr->returning->typmod)
        {
            Node       *placeholder = makeCaseTestExpr(expr);
 
            Assert(((CaseTestExpr *) placeholder)->typeId == ret.typid);
            Assert(((CaseTestExpr *) placeholder)->typeMod == ret.typmod);
 
            jsexpr->result_coercion = coerceJsonExpr(pstate, placeholder,
                                                     jsexpr->returning);
        }
    }
    else
        assignDefaultJsonReturningType(jsexpr->formatted_expr, jsexpr->format,
                                       jsexpr->returning);
}

References Assert(), assignDefaultJsonReturningType(), coerceJsonExpr(), JsonCoercion::expr, JsonExpr::format, JsonExpr::formatted_expr, JSON_VALUE_OP, makeCaseTestExpr(), makeNode, OidIsValid, JsonFuncExpr::op, JsonFuncExpr::output, JsonExpr::result_coercion, JsonExpr::returning, transformJsonOutput(), JsonReturning::typid, JsonReturning::typmod, and JsonCoercion::via_io.

Referenced by transformJsonFuncExpr().

transformJsonIsPredicate()

static Node * transformJsonIsPredicate ( ParseState *  pstate, JsonIsPredicate *  p  )

static

Definition at line 4024 of file parse_expr.c.

{
    Oid         exprtype;
    Node       *expr = transformJsonParseArg(pstate, pred->expr, pred->format,
                                             &exprtype);
 
    /* make resulting expression */
    if (exprtype != TEXTOID && exprtype != JSONOID && exprtype != JSONBOID)
        ereport(ERROR,
                (errcode(ERRCODE_DATATYPE_MISMATCH),
                 errmsg("cannot use type %s in IS JSON predicate",
                        format_type_be(exprtype))));
 
    /* This intentionally(?) drops the format clause. */
    return makeJsonIsPredicate(expr, NULL, pred->item_type,
                               pred->unique_keys, pred->location);
}

References ereport, errcode(), errmsg(), ERROR, JsonIsPredicate::expr, JsonIsPredicate::format, format_type_be(), JsonIsPredicate::item_type, JsonIsPredicate::location, makeJsonIsPredicate(), transformJsonParseArg(), and JsonIsPredicate::unique_keys.

Referenced by transformExprRecurse().

transformJsonObjectAgg()

static Node * transformJsonObjectAgg ( ParseState *  pstate, JsonObjectAgg *  agg  )

static

Definition at line 3844 of file parse_expr.c.

{
    JsonReturning *returning;
    Node       *key;
    Node       *val;
    List       *args;
    const char *aggfnname;
    Oid         aggtype;
 
    key = transformExprRecurse(pstate, (Node *) agg->arg->key);
    val = transformJsonValueExprDefault(pstate, agg->arg->value);
    args = list_make2(key, val);
 
    returning = transformJsonConstructorOutput(pstate, agg->constructor->output,
                                               args);
 
    if (returning->format->format_type == JS_FORMAT_JSONB)
    {
        if (agg->absent_on_null)
            if (agg->unique)
                aggfnname = "pg_catalog.jsonb_object_agg_unique_strict";    /* F_JSONB_OBJECT_AGG_UNIQUE_STRICT */
            else
                aggfnname = "pg_catalog.jsonb_object_agg_strict";   /* F_JSONB_OBJECT_AGG_STRICT */
        else if (agg->unique)
            aggfnname = "pg_catalog.jsonb_object_agg_unique";   /* F_JSONB_OBJECT_AGG_UNIQUE */
        else
            aggfnname = "pg_catalog.jsonb_object_agg";  /* F_JSONB_OBJECT_AGG */
 
        aggtype = JSONBOID;
    }
    else
    {
        if (agg->absent_on_null)
            if (agg->unique)
                aggfnname = "pg_catalog.json_object_agg_unique_strict"; /* F_JSON_OBJECT_AGG_UNIQUE_STRICT */
            else
                aggfnname = "pg_catalog.json_object_agg_strict";    /* F_JSON_OBJECT_AGG_STRICT */
        else if (agg->unique)
            aggfnname = "pg_catalog.json_object_agg_unique";    /* F_JSON_OBJECT_AGG_UNIQUE */
        else
            aggfnname = "pg_catalog.json_object_agg";   /* F_JSON_OBJECT_AGG */
 
        aggtype = JSONOID;
    }
 
    return transformJsonAggConstructor(pstate, agg->constructor, returning,
                                       args, aggfnname, aggtype,
                                       JSCTOR_JSON_OBJECTAGG,
                                       agg->unique, agg->absent_on_null);
}

References JsonObjectAgg::absent_on_null, JsonObjectAgg::arg, generate_unaccent_rules::args, JsonObjectAgg::constructor, JsonReturning::format, JsonFormat::format_type, JS_FORMAT_JSONB, JSCTOR_JSON_OBJECTAGG, JsonKeyValue::key, sort-test::key, list_make2, JsonAggConstructor::output, transformExprRecurse(), transformJsonAggConstructor(), transformJsonConstructorOutput(), transformJsonValueExprDefault(), JsonObjectAgg::unique, val, and JsonKeyValue::value.

Referenced by transformExprRecurse().

transformJsonObjectConstructor()

static Node * transformJsonObjectConstructor ( ParseState *  pstate, JsonObjectConstructor *  ctor  )

static

Definition at line 3661 of file parse_expr.c.

{
    JsonReturning *returning;
    List       *args = NIL;
 
    /* transform key-value pairs, if any */
    if (ctor->exprs)
    {
        ListCell   *lc;
 
        /* transform and append key-value arguments */
        foreach(lc, ctor->exprs)
        {
            JsonKeyValue *kv = castNode(JsonKeyValue, lfirst(lc));
            Node       *key = transformExprRecurse(pstate, (Node *) kv->key);
            Node       *val = transformJsonValueExprDefault(pstate, kv->value);
 
            args = lappend(args, key);
            args = lappend(args, val);
        }
    }
 
    returning = transformJsonConstructorOutput(pstate, ctor->output, args);
 
    return makeJsonConstructorExpr(pstate, JSCTOR_JSON_OBJECT, args, NULL,
                                   returning, ctor->unique,
                                   ctor->absent_on_null, ctor->location);
}

References JsonObjectConstructor::absent_on_null, generate_unaccent_rules::args, castNode, JsonObjectConstructor::exprs, JSCTOR_JSON_OBJECT, JsonKeyValue::key, sort-test::key, lappend(), lfirst, JsonObjectConstructor::location, makeJsonConstructorExpr(), NIL, JsonObjectConstructor::output, transformExprRecurse(), transformJsonConstructorOutput(), transformJsonValueExprDefault(), JsonObjectConstructor::unique, val, and JsonKeyValue::value.

Referenced by transformExprRecurse().

transformJsonOutput()

static JsonReturning* transformJsonOutput ( ParseState *  pstate, const JsonOutput *  output, bool  allow_format  )

static

Definition at line 3473 of file parse_expr.c.

{
    JsonReturning *ret;
 
    /* if output clause is not specified, make default clause value */
    if (!output)
    {
        ret = makeNode(JsonReturning);
 
        ret->format = makeJsonFormat(JS_FORMAT_DEFAULT, JS_ENC_DEFAULT, -1);
        ret->typid = InvalidOid;
        ret->typmod = -1;
 
        return ret;
    }
 
    ret = copyObject(output->returning);
 
    typenameTypeIdAndMod(pstate, output->typeName, &ret->typid, &ret->typmod);
 
    if (output->typeName->setof)
        ereport(ERROR,
                (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                 errmsg("returning SETOF types is not supported in SQL/JSON functions")));
 
    if (ret->format->format_type == JS_FORMAT_DEFAULT)
        /* assign JSONB format when returning jsonb, or JSON format otherwise */
        ret->format->format_type =
            ret->typid == JSONBOID ? JS_FORMAT_JSONB : JS_FORMAT_JSON;
    else
        checkJsonOutputFormat(pstate, ret->format, ret->typid, allow_format);
 
    return ret;
}

References checkJsonOutputFormat(), copyObject, ereport, errcode(), errmsg(), ERROR, JsonReturning::format, JsonFormat::format_type, InvalidOid, JS_ENC_DEFAULT, JS_FORMAT_DEFAULT, JS_FORMAT_JSON, JS_FORMAT_JSONB, makeJsonFormat(), makeNode, output(), typenameTypeIdAndMod(), JsonReturning::typid, and JsonReturning::typmod.

Referenced by transformJsonConstructorOutput(), transformJsonConstructorRet(), transformJsonFuncExpr(), transformJsonFuncExprOutput(), and transformJsonSerializeExpr().

transformJsonParseArg()

static Node* transformJsonParseArg ( ParseState *  pstate, Node *  jsexpr, JsonFormat *  format, Oid *  exprtype  )

static

Definition at line 3972 of file parse_expr.c.

{
    Node       *raw_expr = transformExprRecurse(pstate, jsexpr);
    Node       *expr = raw_expr;
 
    *exprtype = exprType(expr);
 
    /* prepare input document */
    if (*exprtype == BYTEAOID)
    {
        JsonValueExpr *jve;
 
        expr = makeCaseTestExpr(raw_expr);
        expr = makeJsonByteaToTextConversion(expr, format, exprLocation(expr));
        *exprtype = TEXTOID;
 
        jve = makeJsonValueExpr((Expr *) raw_expr, format);
 
        jve->formatted_expr = (Expr *) expr;
        expr = (Node *) jve;
    }
    else
    {
        char        typcategory;
        bool        typispreferred;
 
        get_type_category_preferred(*exprtype, &typcategory, &typispreferred);
 
        if (*exprtype == UNKNOWNOID || typcategory == TYPCATEGORY_STRING)
        {
            expr = coerce_to_target_type(pstate, (Node *) expr, *exprtype,
                                         TEXTOID, -1,
                                         COERCION_IMPLICIT,
                                         COERCE_IMPLICIT_CAST, -1);
            *exprtype = TEXTOID;
        }
 
        if (format->encoding != JS_ENC_DEFAULT)
            ereport(ERROR,
                    (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                     parser_errposition(pstate, format->location),
                     errmsg("cannot use JSON FORMAT ENCODING clause for non-bytea input types")));
    }
 
    return expr;
}

References COERCE_IMPLICIT_CAST, coerce_to_target_type(), COERCION_IMPLICIT, ereport, errcode(), errmsg(), ERROR, exprLocation(), exprType(), format, JsonValueExpr::formatted_expr, get_type_category_preferred(), JS_ENC_DEFAULT, makeCaseTestExpr(), makeJsonByteaToTextConversion(), makeJsonValueExpr(), parser_errposition(), and transformExprRecurse().

Referenced by transformJsonIsPredicate(), and transformJsonParseExpr().

transformJsonParseExpr()

static Node * transformJsonParseExpr ( ParseState *  pstate, JsonParseExpr *  expr  )

static

Definition at line 4511 of file parse_expr.c.

{
    JsonReturning *returning = transformJsonConstructorRet(pstate, jsexpr->output,
                                                           "JSON()");
    Node       *arg;
 
    if (jsexpr->unique_keys)
    {
        /*
         * Coerce string argument to text and then to json[b] in the executor
         * node with key uniqueness check.
         */
        JsonValueExpr *jve = jsexpr->expr;
        Oid         arg_type;
 
        arg = transformJsonParseArg(pstate, (Node *) jve->raw_expr, jve->format,
                                    &arg_type);
 
        if (arg_type != TEXTOID)
            ereport(ERROR,
                    (errcode(ERRCODE_DATATYPE_MISMATCH),
                     errmsg("cannot use non-string types with WITH UNIQUE KEYS clause"),
                     parser_errposition(pstate, jsexpr->location)));
    }
    else
    {
        /*
         * Coerce argument to target type using CAST for compatibility with PG
         * function-like CASTs.
         */
        arg = transformJsonValueExprExt(pstate, jsexpr->expr, JS_FORMAT_JSON,
                                        false, returning->typid);
    }
 
    return makeJsonConstructorExpr(pstate, JSCTOR_JSON_PARSE, list_make1(arg), NULL,
                                   returning, jsexpr->unique_keys, false,
                                   jsexpr->location);
}