Search PostgreSQL documentation

=FunctionsPG18aclitem = aclitem → boolean Are aclitems equal? (Notice that type aclitem lacks the usual set of comparison operators; it has only equality. In turn, aclitem arrays can only be compared for …System Information Functions and Operators › Access Privilege Inquiry Functions ==FunctionsPG18value == value → boolean Equality comparison (this, and the other comparison operators, work on all JSON scalar values) jsonb_path_query_array('[1, "a", 1, 3]', '$[*] ? (@ == 1)') → [1, 1] j…JSON Functions and Operators › The SQL/JSON Path Language › SQL/JSON Path Operators and Methods >FunctionsPG18json #> text[] → json jsonb #> text[] → jsonb Extracts JSON sub-object at the specified path, where path elements can be either field keys or array indexes. '{"a": {"b": ["foo","bar"]}}'::js…JSON Functions and Operators › Processing and Creating JSON Data >=FunctionsPG18value >= value → boolean Greater-than-or-equal-to comparison jsonb_path_query_array('[1, 2, 3]', '$[*] ? (@ >= 2)') → [2, 3]JSON Functions and Operators › The SQL/JSON Path Language › SQL/JSON Path Operators and Methods >>FunctionsPG18bit >> integer → bit Bitwise shift right (string length is preserved) B'10001' >> 2 → 00100Bit String Functions and Operators >>=FunctionsPG18inet >>= inet → boolean Does subnet contain or equal subnet? inet '192.168.1/24' >>= inet '192.168.1/24' → tNetwork Address Functions and Operators >^FunctionsPG18box >^ box → boolean Is first object above second (allows edges to touch)? box '((2,2),(1,1))' >^ box '((1,1),(0,0))' → tGeometric Functions and Operators ?FunctionsPG18geometric_type ?# geometric_type → boolean Do these objects intersect? Available for these pairs of types: (box, box), (lseg, box), (lseg, lseg), (lseg, line), (line, box), (line, line), (pa…Geometric Functions and Operators ?&FunctionsPG18jsonb ?& text[] → boolean Do all of the strings in the text array exist as top-level keys or array elements? '["a", "b", "c"]'::jsonb ?& array['a', 'b'] → tJSON Functions and Operators › Processing and Creating JSON Data ?-FunctionsPG18?- line → boolean ?- lseg → boolean Is line horizontal? ?- lseg '[(-1,0),(1,0)]' → tGeometric Functions and Operators ?-|FunctionsPG18line ?-| line → boolean lseg ?-| lseg → boolean Are lines perpendicular? lseg '[(0,0),(0,1)]' ?-| lseg '[(0,0),(1,0)]' → tGeometric Functions and Operators ?<@FunctionsPG18ltree[] ?<@ ltree → ltree Returns first array entry that is a descendant of ltree, or NULL if none.ltree — hierarchical tree-like data type › Operators and Functions ?@FunctionsPG18ltree[] ?@ ltxtquery → ltree Returns first array entry that matches ltxtquery, or NULL if none.ltree — hierarchical tree-like data type › Operators and Functions ?@>FunctionsPG18ltree[] ?@> ltree → ltree Returns first array entry that is an ancestor of ltree, or NULL if none.ltree — hierarchical tree-like data type › Operators and Functions ?|FunctionsPG18?| line → boolean ?| lseg → boolean Is line vertical? ?| lseg '[(-1,0),(1,0)]' → fGeometric Functions and Operators ?||FunctionsPG18line ?|| line → boolean lseg ?|| lseg → boolean Are lines parallel? lseg '[(-1,0),(1,0)]' ?|| lseg '[(-1,2),(1,2)]' → tGeometric Functions and Operators ?~FunctionsPG18ltree[] ?~ lquery → ltree Returns first array entry that matches lquery, or NULL if none.ltree — hierarchical tree-like data type › Operators and Functions @FunctionsPG18@ numeric_type → numeric_type Absolute value @ -5.0 → 5.0Mathematical Functions and Operators @-@FunctionsPG18@-@ geometric_type → double precision Computes the total length. Available for lseg, path. @-@ path '[(0,0),(1,0),(1,1)]' → 2Geometric Functions and Operators @>FunctionsPG18cube @> cube → boolean Does the first cube contain the second?cube — a multi-dimensional cube data type › Usage @?FunctionsPG18jsonb @? jsonpath → boolean Does JSON path return any item for the specified JSON value? (This is useful only with SQL-standard JSON path expressions, not predicate check expressions, since …JSON Functions and Operators › Processing and Creating JSON Data @@FunctionsPG18@@ geometric_type → point Computes the center point. Available for box, lseg, polygon, circle. @@ box '(2,2),(0,0)' → (1,1)Geometric Functions and Operators ^FunctionsPG18numeric ^ numeric → numeric double precision ^ double precision → double precision Exponentiation 2 ^ 3 → 8 Unlike typical mathematical practice, multiple uses of ^ will associate left to ri…Mathematical Functions and Operators ^@FunctionsPG18text ^@ text → boolean Returns true if the first string starts with the second string (equivalent to the starts_with() function). 'alphabet' ^@ 'alph' → tString Functions and Operators abbrevFunctionsReferenceabbrev Network Address Functions And Operators 10 abbreviated display format as text abbrev ( inet ) → text abbreviated display format as text abbrev ( cidr ) → text abbreviated display form…Functions · Network Address Functions And Operators absFunctionsReferenceabs Mathematical Functions And Operators 10 absolute value abs ( x ) → (same as input) absolute value 11 12 13 Absolute value abs ( numeric_type ) → numeric_type Absolute value 14 15 16 17 1…Functions · Mathematical Functions And Operators acldefaultFunctionsReferenceacldefault System Information Functions And Operators 12 get the default access privileges for an object belonging to ownerId acldefault ( type, ownerId ) → aclitem[] get the default access …Functions · System Information Functions And Operators aclexplodeFunctionsReferenceaclexplode System Information Functions And Operators 12 get aclitem array as tuples aclexplode ( aclitem[] ) → setof record get aclitem array as tuples 13 Returns the aclitem array as a set…Functions · System Information Functions And Operators acosFunctionsReferenceacos Mathematical Functions And Operators 10 inverse cosine acos ( x ) inverse cosine 11 12 13 Inverse cosine, result in radians acos ( double precision ) → double precision Inverse cosine, …Functions · Mathematical Functions And Operators acosdFunctionsReferenceacosd Mathematical Functions And Operators 10 inverse cosine acosd ( x ) inverse cosine 11 12 13 Inverse cosine, result in degrees acosd ( double precision ) → double precision Inverse cosin…Functions · Mathematical Functions And Operators acoshFunctionsReferenceacosh Mathematical Functions And Operators 12 inverse hyperbolic cosine acosh ( x ) inverse hyperbolic cosine 13 Inverse hyperbolic cosine acosh ( double precision ) → double precision Inver…Functions · Mathematical Functions And Operators ageFunctionsReferenceage Date/Time Functions And Operators 10 Subtract arguments, producing a “symbolic” result that uses years and months, rather than just days age ( timestamp, timestamp ) → interval Subtract …Functions · Date/Time Functions And Operators akeysFunctionsPG18akeys ( hstore ) → text[] Extracts an hstore's keys as an array. akeys('a=>1,b=>2') → {a,b}hstore — hstore key/value datatype › hstore Operators and Functions any_valueFunctionsReferenceany_value Aggregate Functions 16 Returns an arbitrary value from the non-null input values. any_value ( anyelement ) → same as input type Returns an arbitrary value from the non-null input v…Functions · Aggregate Functions areaFunctionsReferencearea Geometric Functions And Operators 10 area ( object ) → double precision area 11 12 13 Computes area. Available for box, path, circle. A path input must be closed, else NULL is returned.…Functions · Geometric Functions And Operators array_aggFunctionsReferencearray_agg Aggregate Functions 10 input values, including nulls, concatenated into an array array_agg ( expression ) → array of the argument type input values, including nulls, concatenated i…Functions · Aggregate Functions array_appendFunctionsReferencearray_append Array Functions And Operators 10 append an element to the end of an array array_append ( anyarray, anyelement ) → anyarray append an element to the end of an array 11 12 13 Appe…Functions · Array Functions And Operators array_catFunctionsReferencearray_cat Array Functions And Operators 10 concatenate two arrays array_cat ( anyarray, anyarray ) → anyarray concatenate two arrays 11 12 13 Concatenates two arrays (same as the anyarray ||…Functions · Array Functions And Operators array_dimsFunctionsReferencearray_dims Array Functions And Operators 10 returns a text representation of array's dimensions array_dims ( anyarray ) → text returns a text representation of array's dimensions 11 12 13 Re…Functions · Array Functions And Operators array_fillFunctionsReferencearray_fill Array Functions And Operators 10 returns an array initialized with supplied value and dimensions, optionally with lower bounds other than 1 array_fill ( anyelement, int[] [, int[]…Functions · Array Functions And Operators