Search PostgreSQL documentation

array_lengthFunctionsReferencearray_length Array Functions And Operators 10 returns the length of the requested array dimension array_length ( anyarray, int ) → int returns the length of the requested array dimension 11 …Functions · Array Functions And Operators array_lowerFunctionsReferencearray_lower Array Functions And Operators 10 returns lower bound of the requested array dimension array_lower ( anyarray, int ) → int returns lower bound of the requested array dimension 11 …Functions · Array Functions And Operators array_ndimsFunctionsReferencearray_ndims Array Functions And Operators 10 returns the number of dimensions of the array array_ndims ( anyarray ) → int returns the number of dimensions of the array 11 12 13 Returns the n…Functions · Array Functions And Operators array_positionFunctionsReferencearray_position Array Functions And Operators 10 returns the subscript of the first occurrence of the second argument in the array, starting at the element indicated by the third argument or …Functions · Array Functions And Operators array_positionsFunctionsReferencearray_positions Array Functions And Operators 10 returns an array of subscripts of all occurrences of the second argument in the array given as first argument (array must be one-dimensional)…Functions · Array Functions And Operators array_prependFunctionsReferencearray_prepend Array Functions And Operators 10 append an element to the beginning of an array array_prepend ( anyelement, anyarray ) → anyarray append an element to the beginning of an array…Functions · Array Functions And Operators array_removeFunctionsReferencearray_remove Array Functions And Operators 10 remove all elements equal to the given value from the array (array must be one-dimensional) array_remove ( anyarray, anyelement ) → anyarray rem…Functions · Array Functions And Operators array_replaceFunctionsReferencearray_replace Array Functions And Operators 10 replace each array element equal to the given value with a new value array_replace ( anyarray, anyelement, anyelement ) → anyarray replace each…Functions · Array Functions And Operators array_reverseFunctionsReferencearray_reverse Array Functions And Operators 18 Reverses the first dimension of the array. array_reverse ( anyarray ) → anyarray Reverses the first dimension of the array. 19 20Functions · Array Functions And Operators array_sampleFunctionsReferencearray_sample Array Functions And Operators 16 Returns an array of n items randomly selected from array. n may not exceed the length of array's first dimension. If array is multi-dimensional,…Functions · Array Functions And Operators array_shuffleFunctionsReferencearray_shuffle Array Functions And Operators 16 Randomly shuffles the first dimension of the array. array_shuffle ( anyarray ) → anyarray Randomly shuffles the first dimension of the array. 1…Functions · Array Functions And Operators array_sortFunctionsReferencearray_sort Array Functions And Operators 18 Sorts the first dimension of the array. The sort order is determined by the default sort ordering of the array's element type; however, if the ele…Functions · Array Functions And Operators array_to_jsonFunctionsReferencearray_to_json Json Functions And Operators 10 Returns the array as a JSON array. A PostgreSQL multidimensional array becomes a JSON array of arrays. Line feeds will be added between dimensio…Functions · Json Functions And Operators array_to_stringFunctionsReferencearray_to_string Array Functions And Operators 10 concatenates array elements using supplied delimiter and optional null string array_to_string ( anyarray, text [, text] ) → text concatenates…Functions · Array Functions And Operators array_to_tsvectorFunctionsReferencearray_to_tsvector Text Search Functions And Operators 10 convert array of lexemes to tsvector array_to_tsvector ( text[] ) → tsvector convert array of lexemes to tsvector 11 12 13 Converts a…Functions · Text Search Functions And Operators array_upperFunctionsReferencearray_upper Array Functions And Operators 10 returns upper bound of the requested array dimension array_upper ( anyarray, int ) → int returns upper bound of the requested array dimension 11 …Functions · Array Functions And Operators asciiFunctionsReferenceascii String Functions And Operators 10 ASCII code of the first character of the argument. For UTF8 returns the Unicode code point of the character. For other multibyte encodings, the argume…Functions · String Functions And Operators asinFunctionsReferenceasin Mathematical Functions And Operators 10 inverse sine asin ( x ) inverse sine 11 12 13 Inverse sine, result in radians asin ( double precision ) → double precision Inverse sine, result i…Functions · Mathematical Functions And Operators asindFunctionsReferenceasind Mathematical Functions And Operators 10 inverse sine asind ( x ) inverse sine 11 12 13 Inverse sine, result in degrees asind ( double precision ) → double precision Inverse sine, resul…Functions · Mathematical Functions And Operators asinhFunctionsReferenceasinh Mathematical Functions And Operators 12 inverse hyperbolic sine asinh ( x ) inverse hyperbolic sine 13 Inverse hyperbolic sine asinh ( double precision ) → double precision Inverse hyp…Functions · Mathematical Functions And Operators atanFunctionsReferenceatan Mathematical Functions And Operators 10 inverse tangent atan ( x ) inverse tangent 11 12 13 Inverse tangent, result in radians atan ( double precision ) → double precision Inverse tange…Functions · Mathematical Functions And Operators atan2FunctionsReferenceatan2 Mathematical Functions And Operators 10 inverse tangent of y/x atan2 ( y, x ) inverse tangent of y/x 11 12 13 Inverse tangent of y/x, result in radians atan2 ( y double precision, x do…Functions · Mathematical Functions And Operators atan2dFunctionsReferenceatan2d Mathematical Functions And Operators 10 inverse tangent of y/x atan2d ( y, x ) inverse tangent of y/x 11 12 13 Inverse tangent of y/x, result in degrees atan2d ( y double precision, x…Functions · Mathematical Functions And Operators atandFunctionsReferenceatand Mathematical Functions And Operators 10 inverse tangent atand ( x ) inverse tangent 11 12 13 Inverse tangent, result in degrees atand ( double precision ) → double precision Inverse ta…Functions · Mathematical Functions And Operators atanhFunctionsReferenceatanh Mathematical Functions And Operators 12 inverse hyperbolic tangent atanh ( x ) inverse hyperbolic tangent 13 Inverse hyperbolic tangent atanh ( double precision ) → double precision In…Functions · Mathematical Functions And Operators avalsFunctionsPG18avals ( hstore ) → text[] Extracts an hstore's values as an array. avals('a=>1,b=>2') → {1,2}hstore — hstore key/value datatype › hstore Operators and Functions avgFunctionsReferenceavg Aggregate Functions 10 the average (arithmetic mean) of all non-null input values avg ( expression ) → numeric for any integer-type argument, double precision for a floating-point argume…Functions · Aggregate Functions bit_andFunctionsReferencebit_and Aggregate Functions 10 the bitwise AND of all non-null input values, or null if none bit_and ( expression ) → same as argument data type the bitwise AND of all non-null input values,…Functions · Aggregate Functions bit_countFunctionsReferencebit_count Binary String Functions And Operators 14 Returns the number of bits set in the binary string (also known as “popcount”). bit_count ( bytes bytea ) → bigint Returns the number of bi…Functions · Binary String Functions And Operators bit_lengthFunctionsReferencebit_length String Functions And Operators 10 Number of bits in string bit_length ( string ) → int Number of bits in string 11 12 13 Returns number of bits in the string (8 times the octet_le…Functions · String Functions And Operators bit_orFunctionsReferencebit_or Aggregate Functions 10 the bitwise OR of all non-null input values, or null if none bit_or ( expression ) → same as argument data type the bitwise OR of all non-null input values, or …Functions · Aggregate Functions bit_xorFunctionsReferencebit_xor Aggregate Functions 14 Computes the bitwise exclusive OR of all non-null input values. Can be useful as a checksum for an unordered set of values. bit_xor ( smallint ) → smallint Com…Functions · Aggregate Functions bool_andFunctionsReferencebool_and Aggregate Functions 10 true if all input values are true, otherwise false bool_and ( expression ) → bool true if all input values are true, otherwise false 11 12 13 Returns true if …Functions · Aggregate Functions bool_orFunctionsReferencebool_or Aggregate Functions 10 true if at least one input value is true, otherwise false bool_or ( expression ) → bool true if at least one input value is true, otherwise false 11 12 13 Retu…Functions · Aggregate Functions bound_boxFunctionsReferencebound_box Geometric Functions And Operators 10 boxes to bounding box bound_box ( box, box ) → box boxes to bounding box 11 12 13 Computes bounding box of two boxes. bound_box ( box, box ) → …Functions · Geometric Functions And Operators boxFunctionsReferencebox Geometric Functions And Operators 10 circle to box box ( circle ) → box circle to box box ( point ) → box point to empty box box ( point, point ) → box points to box box ( polygon ) → bo…Functions · Geometric Functions And Operators brin_desummarize_rangeFunctionsReferencebrin_desummarize_range System Administration Functions 10 de-summarize the page range covering the given block, if summarized brin_desummarize_range ( index regclass, blockNumber bigint ) → …Functions · System Administration Functions brin_summarize_new_valuesFunctionsReferencebrin_summarize_new_values System Administration Functions 10 summarize page ranges not already summarized brin_summarize_new_values ( index regclass ) → integer summarize page ranges not alr…Functions · System Administration Functions brin_summarize_rangeFunctionsReferencebrin_summarize_range System Administration Functions 10 summarize the page range covering the given block, if not already summarized brin_summarize_range ( index regclass, blockNumber bigint…Functions · System Administration Functions broadcastFunctionsReferencebroadcast Network Address Functions And Operators 10 broadcast address for network broadcast ( inet ) → inet broadcast address for network 11 12 13 Computes the broadcast address for the add…Functions · Network Address Functions And Operators