• Alexander Korotkov's avatar
    Partial implementation of SQL/JSON path language · 72b64603
    Alexander Korotkov authored
    SQL 2016 standards among other things contains set of SQL/JSON features for
    JSON processing inside of relational database.  The core of SQL/JSON is JSON
    path language, allowing access parts of JSON documents and make computations
    over them.  This commit implements partial support JSON path language as
    separate datatype called "jsonpath".  The implementation is partial because
    it's lacking datetime support and suppression of numeric errors.  Missing
    features will be added later by separate commits.
    
    Support of SQL/JSON features requires implementation of separate nodes, and it
    will be considered in subsequent patches.  This commit includes following
    set of plain functions, allowing to execute jsonpath over jsonb values:
    
     * jsonb_path_exists(jsonb, jsonpath[, jsonb, bool]),
     * jsonb_path_match(jsonb, jsonpath[, jsonb, bool]),
     * jsonb_path_query(jsonb, jsonpath[, jsonb, bool]),
     * jsonb_path_query_array(jsonb, jsonpath[, jsonb, bool]).
     * jsonb_path_query_first(jsonb, jsonpath[, jsonb, bool]).
    
    This commit also implements "jsonb @? jsonpath" and "jsonb @@ jsonpath", which
    are wrappers over jsonpath_exists(jsonb, jsonpath) and jsonpath_predicate(jsonb,
    jsonpath) correspondingly.  These operators will have an index support
    (implemented in subsequent patches).
    
    Catversion bumped, to add new functions and operators.
    
    Code was written by Nikita Glukhov and Teodor Sigaev, revised by me.
    Documentation was written by Oleg Bartunov and Liudmila Mantrova.  The work
    was inspired by Oleg Bartunov.
    
    Discussion: https://postgr.es/m/fcc6fc6a-b497-f39a-923d-aa34d0c588e8%402ndQuadrant.com
    Author: Nikita Glukhov, Teodor Sigaev, Alexander Korotkov, Oleg Bartunov, Liudmila Mantrova
    Reviewed-by: Tomas Vondra, Andrew Dunstan, Pavel Stehule, Alexander Korotkov
    72b64603
parallel_schedule 4.41 KB