Search PostgreSQL documentation

encodeFunctionsReferenceencode Binary String Functions And Operators 10 Encode binary data into a textual representation. Supported formats are: base64, hex, escape. escape converts zero bytes and high-bit-set byte…Functions · Binary String Functions And Operators enum_firstFunctionsReferenceenum_first Enum Support Functions 10 Returns the first value of the input enum type enum_first ( anyenum ) Returns the first value of the input enum type 11 12 13 Returns the first value of …Functions · Enum Support Functions enum_lastFunctionsReferenceenum_last Enum Support Functions 10 Returns the last value of the input enum type enum_last ( anyenum ) Returns the last value of the input enum type 11 12 13 Returns the last value of the i…Functions · Enum Support Functions enum_rangeFunctionsReferenceenum_range Enum Support Functions 10 Returns all values of the input enum type in an ordered array enum_range ( anyenum ) Returns all values of the input enum type in an ordered array enum_r…Functions · Enum Support Functions erfFunctionsReferenceerf Mathematical Functions And Operators 16 Error function erf ( double precision ) → double precision Error function 17 18 19 20Functions · Mathematical Functions And Operators erfcFunctionsReferenceerfc Mathematical Functions And Operators 16 Complementary error function (1 - erf(x), without loss of precision for large inputs) erfc ( double precision ) → double precision Complementary …Functions · Mathematical Functions And Operators error_on_nullFunctionsReferenceerror_on_null Comparison Functions And Operators 19 Checks if the input is the null value, generating an error if so; otherwise, returns the input. error_on_null ( anyelement ) → anyelement …Functions · Comparison Functions And Operators everyFunctionsReferenceevery Aggregate Functions 10 equivalent to bool_and every ( expression ) → bool equivalent to bool_and 11 12 13 This is the SQL standard's equivalent to bool_and. every ( boolean ) → boolean…Functions · Aggregate Functions existFunctionsPG18exist ( hstore, text ) → boolean Does hstore contain key? exist('a=>1', 'a') → thstore — hstore key/value datatype › hstore Operators and Functions expFunctionsReferenceexp Mathematical Functions And Operators 10 exponential exp ( dp or numeric ) → (same as input) exponential 11 12 13 Exponential (e raised to the given power) exp ( numeric ) → numeric Expon…Functions · Mathematical Functions And Operators extractFunctionsReferenceextract Date/Time Functions And Operators 10 Get subfield; see Section 9.9.1 extract ( field from timestamp ) → double precision Get subfield; see Section 9.9.1 extract ( field from interval…Functions · Date/Time Functions And Operators factorialFunctionsReferencefactorial Mathematical Functions And Operators 10 factorial ( bigint ) → numeric factorial 11 12 13 Factorial factorial ( bigint ) → numeric Factorial 14 15 16 17 18 19 20 9.5 9.6Functions · Mathematical Functions And Operators familyFunctionsReferencefamily Network Address Functions And Operators 10 extract family of address; 4 for IPv4, 6 for IPv6 family ( inet ) → int extract family of address; 4 for IPv4, 6 for IPv6 11 12 13 Returns t…Functions · Network Address Functions And Operators first_valueFunctionsReferencefirst_value Window Functions 10 returns value evaluated at the row that is the first row of the window frame first_value ( value any ) → same type as value returns value evaluated at the row…Functions · Window Functions floorFunctionsReferencefloor Mathematical Functions And Operators 10 nearest integer less than or equal to argument floor ( dp or numeric ) → (same as input) nearest integer less than or equal to argument 11 12 13…Functions · Mathematical Functions And Operators formatFunctionsReferenceformat String Functions And Operators 10 Format arguments according to a format string. This function is similar to the C function sprintf. See Section 9.4.1. format ( formatstr text [, form…Functions · String Functions And Operators format_typeFunctionsReferenceformat_type System Information Functions And Operators 10 get SQL name of a data type format_type ( type_oid, typemod ) → text get SQL name of a data type 11 12 13 Returns the SQL name for a…Functions · System Information Functions And Operators gammaFunctionsReferencegamma Mathematical Functions And Operators 18 Gamma function gamma ( double precision ) → double precision Gamma function 19 20Functions · Mathematical Functions And Operators gc_to_secFunctionsPG18gc_to_sec ( float8 ) → float8 Converts the great circle distance between two points on the surface of the Earth to the normal straight line (secant) distance between them.earthdistance — calculate great-circle distances › Cube-Based Earth Distances gcdFunctionsReferencegcd Mathematical Functions And Operators 13 Greatest common divisor (the largest positive number that divides both inputs with no remainder); returns 0 if both inputs are zero; available for…Functions · Mathematical Functions And Operators gen_random_uuidFunctionsReferencegen_random_uuid Uuid Functions 13 This function returns a version 4 (random) UUID. This is the most commonly used type of UUID and is appropriate for most applications. gen_random_uuid () → …Functions · Uuid Functions generate_seriesFunctionsReferencegenerate_series Set Returning Functions 10 Generate a series of values, from start to stop with a step size of one generate_series ( start, stop ) → setof int, setof bigint, or setof numeric…Functions · Set Returning Functions generate_subscriptsFunctionsReferencegenerate_subscripts Set Returning Functions 10 Generate a series comprising the given array's subscripts. generate_subscripts ( array anyarray, dim int ) → setof int Generate a series compri…Functions · Set Returning Functions get_bitFunctionsReferenceget_bit Binary String Functions And Operators 10 Extract bit from string get_bit ( string, offset ) → int Extract bit from string 11 12 13 Extracts n'th bit from binary string. get_bit ( byt…Functions · Binary String Functions And Operators get_byteFunctionsReferenceget_byte Binary String Functions And Operators 10 Extract byte from string get_byte ( string, offset ) → int Extract byte from string 11 12 13 Extracts n'th byte from binary string. get_byte…Functions · Binary String Functions And Operators get_current_ts_configFunctionsReferenceget_current_ts_config Text Search Functions And Operators 10 get default text search configuration get_current_ts_config ( ) → regconfig get default text search configuration 11 12 13 Return…Functions · Text Search Functions And Operators getdatabaseencodingFunctionsReferencegetdatabaseencoding String Functions And Operators 20 Returns current database encoding name. getdatabaseencoding ( ) → name Returns current database encoding name.Functions · String Functions And Operators gin_clean_pending_listFunctionsReferencegin_clean_pending_list System Administration Functions 10 move GIN pending list entries into main index structure gin_clean_pending_list ( index regclass ) → bigint move GIN pending list ent…Functions · System Administration Functions GREATESTFunctionsReferenceGREATEST Conditional Expressions 10 GREATEST(value [, ...]) 11 12 13 14 15 16 17 18 19 20 9.0 9.1 9.2 9.3 9.4 9.5 9.6Functions · Conditional Expressions GROUPINGFunctionsReferenceGROUPING Aggregate Functions 10 Integer bit mask indicating which arguments are not being included in the current grouping set GROUPING ( args... ) → integer Integer bit mask indicating whic…Functions · Aggregate Functions has_any_column_privilegeFunctionsReferencehas_any_column_privilege System Information Functions And Operators 10 does user have privilege for any column of table has_any_column_privilege ( user, table, privilege ) → boolean does use…Functions · System Information Functions And Operators has_column_privilegeFunctionsReferencehas_column_privilege System Information Functions And Operators 10 does user have privilege for column has_column_privilege ( user, table, column, privilege ) → boolean does user have privil…Functions · System Information Functions And Operators has_database_privilegeFunctionsReferencehas_database_privilege System Information Functions And Operators 10 does user have privilege for database has_database_privilege ( user, database, privilege ) → boolean does user have privi…Functions · System Information Functions And Operators has_foreign_data_wrapper_privilegeFunctionsReferencehas_foreign_data_wrapper_privilege System Information Functions And Operators 10 does user have privilege for foreign-data wrapper has_foreign_data_wrapper_privilege ( user, fdw, privilege )…Functions · System Information Functions And Operators has_function_privilegeFunctionsReferencehas_function_privilege System Information Functions And Operators 10 does user have privilege for function has_function_privilege ( user, function, privilege ) → boolean does user have privi…Functions · System Information Functions And Operators has_language_privilegeFunctionsReferencehas_language_privilege System Information Functions And Operators 10 does user have privilege for language has_language_privilege ( user, language, privilege ) → boolean does user have privi…Functions · System Information Functions And Operators has_largeobject_privilegeFunctionsReferencehas_largeobject_privilege System Information Functions And Operators 18 Does user have privilege for large object? Allowable privilege types are SELECT and UPDATE. has_largeobject_privilege …Functions · System Information Functions And Operators has_parameter_privilegeFunctionsReferencehas_parameter_privilege System Information Functions And Operators 15 Does user have privilege for configuration parameter? The parameter name is case-insensitive. Allowable privilege types …Functions · System Information Functions And Operators has_schema_privilegeFunctionsReferencehas_schema_privilege System Information Functions And Operators 10 does user have privilege for schema has_schema_privilege ( user, schema, privilege ) → boolean does user have privilege for…Functions · System Information Functions And Operators has_sequence_privilegeFunctionsReferencehas_sequence_privilege System Information Functions And Operators 10 does user have privilege for sequence has_sequence_privilege ( user, sequence, privilege ) → boolean does user have privi…Functions · System Information Functions And Operators