Search PostgreSQL documentation

btrimFunctionsReferencebtrim String Functions And Operators 10 Remove the longest string consisting only of characters in characters (a space by default) from the start and end of string btrim ( string text [, cha…Functions · String Functions And Operators cardinalityFunctionsReferencecardinality Array Functions And Operators 10 returns the total number of elements in the array, or 0 if the array is empty cardinality ( anyarray ) → int returns the total number of elements…Functions · Array Functions And Operators casefoldFunctionsReferencecasefold String Functions And Operators 18 Performs case folding of the input string according to the collation. Case folding is similar to case conversion, but the purpose of case folding i…Functions · String Functions And Operators cbrtFunctionsReferencecbrt Mathematical Functions And Operators 10 cube root cbrt ( dp ) → dp cube root 11 12 13 Cube root cbrt ( double precision ) → double precision Cube root 14 15 16 17 18 19 20 9.0 9.1 9.2 9…Functions · Mathematical Functions And Operators ceilFunctionsReferenceceil Mathematical Functions And Operators 10 nearest integer greater than or equal to argument ceil ( dp or numeric ) → (same as input) nearest integer greater than or equal to argument 11 1…Functions · Mathematical Functions And Operators ceilingFunctionsReferenceceiling Mathematical Functions And Operators 10 nearest integer greater than or equal to argument (same as ceil) ceiling ( dp or numeric ) → (same as input) nearest integer greater than or e…Functions · Mathematical Functions And Operators centerFunctionsReferencecenter Geometric Functions And Operators 10 center ( object ) → point center 11 12 13 Computes center point. Available for box, circle. center ( geometric_type ) → point Computes center poin…Functions · Geometric Functions And Operators char_lengthFunctionsReferencechar_length String Functions And Operators 10 Number of characters in string char_length ( string ) → int Number of characters in string 11 12 13 Returns number of characters in the string. …Functions · String Functions And Operators character_lengthFunctionsReferencecharacter_length String Functions And Operators 10 Number of characters in string character_length ( string ) → int Number of characters in string 11 12 13 Returns number of characters in th…Functions · String Functions And Operators chrFunctionsReferencechr String Functions And Operators 10 Character with the given code. For UTF8 the argument is treated as a Unicode code point. For other multibyte encodings the argument must designate an AS…Functions · String Functions And Operators circleFunctionsReferencecircle Geometric Functions And Operators 10 box to circle circle ( box ) → circle box to circle circle ( point, double precision ) → circle center and radius to circle circle ( polygon ) → c…Functions · Geometric Functions And Operators clock_timestampFunctionsReferenceclock_timestamp Date/Time Functions And Operators 10 Current date and time (changes during statement execution); see Section 9.9.4 clock_timestamp ( ) → timestamp with time zone Current date…Functions · Date/Time Functions And Operators COALESCEFunctionsReferenceCOALESCE Conditional Expressions 10 The COALESCE function returns the first of its arguments that is not null. Null is returned only if all arguments are null. It is often used to substitute…Functions · Conditional Expressions col_descriptionFunctionsReferencecol_description System Information Functions And Operators 10 get comment for a table column col_description ( table_oid, column_number ) → text get comment for a table column 11 12 13 Retur…Functions · System Information Functions And Operators concatFunctionsReferenceconcat String Functions And Operators 10 Concatenate the text representations of all the arguments. NULL arguments are ignored. concat ( str "any" [, str "any" [, ...] ] ) → text Concatenate…Functions · String Functions And Operators concat_wsFunctionsReferenceconcat_ws String Functions And Operators 10 Concatenate all but the first argument with separators. The first argument is used as the separator string. NULL arguments are ignored. concat_ws …Functions · String Functions And Operators connectbyFunctionsPG18connectby ( relname text, keyid_fld text, parent_keyid_fld text [, orderby_fld text ], start_with text, max_depth integer [, branch_delim text ] ) → setof record Produces a representation of…tablefunc — functions that return tables (crosstab and others) › Functions Provided convertFunctionsReferenceconvert Binary String Functions And Operators 10 Convert string to dest_encoding. The original encoding is specified by src_encoding. The string must be valid in this encoding. Conversions c…Functions · Binary String Functions And Operators convert_fromFunctionsReferenceconvert_from Binary String Functions And Operators 10 Convert string to the database encoding. The original encoding is specified by src_encoding. The string must be valid in this encoding. …Functions · Binary String Functions And Operators convert_toFunctionsReferenceconvert_to Binary String Functions And Operators 10 Convert string to dest_encoding. convert_to ( string text, dest_encoding name ) → bytea Convert string to dest_encoding. 11 12 13 Converts…Functions · Binary String Functions And Operators corrFunctionsReferencecorr Aggregate Functions 10 correlation coefficient corr ( Y, X ) → double precision correlation coefficient 11 12 13 Computes the correlation coefficient. corr ( Y double precision, X doubl…Functions · Aggregate Functions cosFunctionsReferencecos Mathematical Functions And Operators 10 cosine cos ( x ) cosine 11 12 13 Cosine, argument in radians cos ( double precision ) → double precision Cosine, argument in radians 14 15 16 17 1…Functions · Mathematical Functions And Operators cosdFunctionsReferencecosd Mathematical Functions And Operators 10 cosine cosd ( x ) cosine 11 12 13 Cosine, argument in degrees cosd ( double precision ) → double precision Cosine, argument in degrees 14 15 16 1…Functions · Mathematical Functions And Operators coshFunctionsReferencecosh Mathematical Functions And Operators 12 hyperbolic cosine cosh ( x ) hyperbolic cosine 13 Hyperbolic cosine cosh ( double precision ) → double precision Hyperbolic cosine 14 15 16 17 18…Functions · Mathematical Functions And Operators cotFunctionsReferencecot Mathematical Functions And Operators 10 cotangent cot ( x ) cotangent 11 12 13 Cotangent, argument in radians cot ( double precision ) → double precision Cotangent, argument in radians 1…Functions · Mathematical Functions And Operators cotdFunctionsReferencecotd Mathematical Functions And Operators 10 cotangent cotd ( x ) cotangent 11 12 13 Cotangent, argument in degrees cotd ( double precision ) → double precision Cotangent, argument in degree…Functions · Mathematical Functions And Operators countFunctionsReferencecount Aggregate Functions 10 number of input rows count ( * ) → bigint number of input rows count ( expression ) → bigint number of input rows for which the value of expression is not null 1…Functions · Aggregate Functions covar_popFunctionsReferencecovar_pop Aggregate Functions 10 population covariance covar_pop ( Y, X ) → double precision population covariance 11 12 13 Computes the population covariance. covar_pop ( Y double precision…Functions · Aggregate Functions covar_sampFunctionsReferencecovar_samp Aggregate Functions 10 sample covariance covar_samp ( Y, X ) → double precision sample covariance 11 12 13 Computes the sample covariance. covar_samp ( Y double precision, X doubl…Functions · Aggregate Functions crc32FunctionsReferencecrc32 Binary String Functions And Operators 18 Computes the CRC-32 value of the binary string. crc32 ( bytea ) → bigint Computes the CRC-32 value of the binary string. 19 20Functions · Binary String Functions And Operators crc32cFunctionsReferencecrc32c Binary String Functions And Operators 18 Computes the CRC-32C value of the binary string. crc32c ( bytea ) → bigint Computes the CRC-32C value of the binary string. 19 20Functions · Binary String Functions And Operators crosstabFunctionsPG18crosstab ( sql text ) → setof record Produces a “pivot table” containing row names plus N value columns, where N is determined by the row type specified in the calling query.tablefunc — functions that return tables (crosstab and others) › Functions Provided crosstabNFunctionsPG18crosstabN ( sql text ) → setof table_crosstab_N Produces a “pivot table” containing row names plus N value columns. crosstab2, crosstab3, and crosstab4 are predefined, but you can create add…tablefunc — functions that return tables (crosstab and others) › Functions Provided cubeFunctionsPG18cube ( float8 ) → cube Makes a one dimensional cube with both coordinates the same. cube(1) → (1)cube — a multi-dimensional cube data type › Usage cube_dimFunctionsPG18cube_dim ( cube ) → integer Returns the number of dimensions of the cube. cube_dim('(1,2),(3,4)') → 2cube — a multi-dimensional cube data type › Usage cube_distanceFunctionsPG18cube_distance ( cube, cube ) → float8 Returns the distance between two cubes. If both cubes are points, this is the normal distance function. cube_distance('(1,2)', '(3,4)') → 2.828427124746…cube — a multi-dimensional cube data type › Usage cube_enlargeFunctionsPG18cube_enlarge ( c cube, r double, n integer ) → cube Increases the size of the cube by the specified radius r in at least n dimensions. If the radius is negative the cube is shrunk instead. A…cube — a multi-dimensional cube data type › Usage cube_interFunctionsPG18cube_inter ( cube, cube ) → cube Produces the intersection of two cubes. cube_inter('(1,2)', '(3,4)') → (3, 4),(1, 2)cube — a multi-dimensional cube data type › Usage cube_is_pointFunctionsPG18cube_is_point ( cube ) → boolean Returns true if the cube is a point, that is, the two defining corners are the same. cube_is_point(cube(1,1)) → tcube — a multi-dimensional cube data type › Usage cube_ll_coordFunctionsPG18cube_ll_coord ( cube, integer ) → float8 Returns the n-th coordinate value for the lower left corner of the cube. cube_ll_coord('(1,2),(3,4)', 2) → 2cube — a multi-dimensional cube data type › Usage