Search PostgreSQL documentation

jsonb_extract_path_textFunctionsReferencejsonb_extract_path_text Json Functions And Operators 10 Returns JSON value pointed to by path_elems as text (equivalent to #>> operator). jsonb_extract_path_text ( from_json jsonb, VARIADIC …Functions · Json Functions And Operators jsonb_insertFunctionsReferencejsonb_insert Json Functions And Operators 10 Returns target with new_value inserted. If target section designated by path is in a JSONB array, new_value will be inserted before target or aft…Functions · Json Functions And Operators jsonb_objectFunctionsReferencejsonb_object Json Functions And Operators 10 Builds a JSON object out of a text array. The array must have either exactly one dimension with an even number of members, in which case they are…Functions · Json Functions And Operators jsonb_object_aggFunctionsReferencejsonb_object_agg Aggregate Functions 10 aggregates name/value pairs as a JSON object; values can be null, but not names jsonb_object_agg ( name, value ) → jsonb aggregates name/value pairs a…Functions · Aggregate Functions jsonb_object_agg_strictFunctionsReferencejsonb_object_agg_strict Aggregate Functions 16 Collects all the key/value pairs into a JSON object. Key arguments are coerced to text; value arguments are converted as per to_json or to_json…Functions · Aggregate Functions jsonb_object_agg_uniqueFunctionsReferencejsonb_object_agg_unique Aggregate Functions 16 Collects all the key/value pairs into a JSON object. Key arguments are coerced to text; value arguments are converted as per to_json or to_json…Functions · Aggregate Functions jsonb_object_agg_unique_strictFunctionsReferencejsonb_object_agg_unique_strict Aggregate Functions 16 Collects all the key/value pairs into a JSON object. Key arguments are coerced to text; value arguments are converted as per to_json or …Functions · Aggregate Functions jsonb_object_keysFunctionsReferencejsonb_object_keys Json Functions And Operators 10 Returns set of keys in the outermost JSON object. jsonb_object_keys ( jsonb ) → setof text Returns set of keys in the outermost JSON object.…Functions · Json Functions And Operators jsonb_path_existsFunctionsReferencejsonb_path_exists Json Functions And Operators 12 Checks whether JSON path returns any item for the specified JSON value. jsonb_path_exists ( target jsonb, path jsonpath [, vars jsonb [, sil…Functions · Json Functions And Operators jsonb_path_exists_tzFunctionsReferencejsonb_path_exists_tz Json Functions And Operators 13 These functions act like their counterparts described above without the _tz suffix, except that these functions support comparisons of da…Functions · Json Functions And Operators jsonb_path_matchFunctionsReferencejsonb_path_match Json Functions And Operators 12 Returns the result of JSON path predicate check for the specified JSON value. Only the first item of the result is taken into account. If the…Functions · Json Functions And Operators jsonb_path_match_tzFunctionsReferencejsonb_path_match_tz Json Functions And Operators 13 These functions act like their counterparts described above without the _tz suffix, except that these functions support comparisons of dat…Functions · Json Functions And Operators jsonb_path_queryFunctionsReferencejsonb_path_query Json Functions And Operators 12 Gets all JSON items returned by JSON path for the specified JSON value. jsonb_path_query ( target jsonb, path jsonpath [, vars jsonb [, silen…Functions · Json Functions And Operators jsonb_path_query_arrayFunctionsReferencejsonb_path_query_array Json Functions And Operators 12 Gets all JSON items returned by JSON path for the specified JSON value and wraps result into an array. jsonb_path_query_array ( target …Functions · Json Functions And Operators jsonb_path_query_array_tzFunctionsReferencejsonb_path_query_array_tz Json Functions And Operators 13 These functions act like their counterparts described above without the _tz suffix, except that these functions support comparisons …Functions · Json Functions And Operators jsonb_path_query_firstFunctionsReferencejsonb_path_query_first Json Functions And Operators 12 Gets the first JSON item returned by JSON path for the specified JSON value. Returns NULL on no results. jsonb_path_query_first ( targe…Functions · Json Functions And Operators jsonb_path_query_first_tzFunctionsReferencejsonb_path_query_first_tz Json Functions And Operators 13 These functions act like their counterparts described above without the _tz suffix, except that these functions support comparisons …Functions · Json Functions And Operators jsonb_path_query_tzFunctionsReferencejsonb_path_query_tz Json Functions And Operators 13 These functions act like their counterparts described above without the _tz suffix, except that these functions support comparisons of dat…Functions · Json Functions And Operators jsonb_populate_recordFunctionsReferencejsonb_populate_record Json Functions And Operators 10 Expands the object in from_json to a row whose columns match the record type defined by base (see note below). jsonb_populate_record ( b…Functions · Json Functions And Operators jsonb_populate_record_validFunctionsReferencejsonb_populate_record_valid Json Functions And Operators 17 Function for testing jsonb_populate_record. Returns true if the input jsonb_populate_record would finish without an error for the …Functions · Json Functions And Operators jsonb_populate_recordsetFunctionsReferencejsonb_populate_recordset Json Functions And Operators 10 Expands the outermost array of objects in from_json to a set of rows whose columns match the record type defined by base (see note be…Functions · Json Functions And Operators jsonb_prettyFunctionsReferencejsonb_pretty Json Functions And Operators 10 Returns from_json as indented JSON text. jsonb_pretty ( from_json jsonb ) → text Returns from_json as indented JSON text. 11 12 13 Converts the g…Functions · Json Functions And Operators jsonb_set_laxFunctionsReferencejsonb_set_lax Json Functions And Operators 13 If new_value is not NULL, behaves identically to jsonb_set. Otherwise behaves according to the value of null_value_treatment which must be one o…Functions · Json Functions And Operators jsonb_strip_nullsFunctionsReferencejsonb_strip_nulls Json Functions And Operators 10 Returns from_json with all object fields that have null values omitted. Other null values are untouched. jsonb_strip_nulls ( from_json jsonb…Functions · Json Functions And Operators jsonb_to_recordFunctionsReferencejsonb_to_record Json Functions And Operators 10 Builds an arbitrary record from a JSON object (see note below). As with all functions returning record, the caller must explicitly define the …Functions · Json Functions And Operators jsonb_to_recordsetFunctionsReferencejsonb_to_recordset Json Functions And Operators 10 Builds an arbitrary set of records from a JSON array of objects (see note below). As with all functions returning record, the caller must e…Functions · Json Functions And Operators jsonb_to_tsvectorFunctionsReferencejsonb_to_tsvector Text Search Functions And Operators 13 Selects each item in the JSON document that is requested by the filter and converts each one to a tsvector, normalizing words accordi…Functions · Text Search Functions And Operators jsonb_typeofFunctionsReferencejsonb_typeof Json Functions And Operators 10 Returns the type of the outermost JSON value as a text string. Possible types are object, array, string, number, boolean, and null. jsonb_typeof …Functions · Json Functions And Operators justify_daysFunctionsReferencejustify_days Date/Time Functions And Operators 10 Adjust interval so 30-day time periods are represented as months justify_days ( interval ) → interval Adjust interval so 30-day time periods…Functions · Date/Time Functions And Operators justify_hoursFunctionsReferencejustify_hours Date/Time Functions And Operators 10 Adjust interval so 24-hour time periods are represented as days justify_hours ( interval ) → interval Adjust interval so 24-hour time perio…Functions · Date/Time Functions And Operators justify_intervalFunctionsReferencejustify_interval Date/Time Functions And Operators 10 Adjust interval using justify_days and justify_hours, with additional sign adjustments justify_interval ( interval ) → interval Adjust i…Functions · Date/Time Functions And Operators lagFunctionsReferencelag Window Functions 10 returns value evaluated at the row that is offset rows before the current row within the partition; if there is no such row, instead return default (which must be of …Functions · Window Functions last_valueFunctionsReferencelast_value Window Functions 10 returns value evaluated at the row that is the last row of the window frame last_value ( value any ) → same type as value returns value evaluated at the row th…Functions · Window Functions lastvalFunctionsReferencelastval Sequence Manipulation Functions 10 Return value most recently obtained with nextval for any sequence lastval ( ) → bigint Return value most recently obtained with nextval for any seq…Functions · Sequence Manipulation Functions latitudeFunctionsPG18latitude ( earth ) → float8 Returns the latitude in degrees of a point on the surface of the Earth.earthdistance — calculate great-circle distances › Cube-Based Earth Distances lcaFunctionsPG18lca ( ltree [, ltree [, ... ]] ) → ltree Computes longest common ancestor of paths (up to 8 arguments are supported). lca('1.2.3', '1.2.3.4.5.6') → 1.2ltree — hierarchical tree-like data type › Operators and Functions lcmFunctionsReferencelcm Mathematical Functions And Operators 13 Least common multiple (the smallest strictly positive number that is an integral multiple of both inputs); returns 0 if either input is zero; avai…Functions · Mathematical Functions And Operators leadFunctionsReferencelead Window Functions 10 returns value evaluated at the row that is offset rows after the current row within the partition; if there is no such row, instead return default (which must be of …Functions · Window Functions LEASTFunctionsReferenceLEAST Conditional Expressions 10 The GREATEST and LEAST functions select the largest or smallest value from a list of any number of expressions. The expressions must all be convertible to a …Functions · Conditional Expressions leftFunctionsReferenceleft String Functions And Operators 10 Return first n characters in the string. When n is negative, return all but last |n| characters. left ( str text, n int ) → text Return first n charact…Functions · String Functions And Operators