Search PostgreSQL documentation

has_server_privilegeFunctionsReferencehas_server_privilege System Information Functions And Operators 10 does user have privilege for foreign server has_server_privilege ( user, server, privilege ) → boolean does user have privi…Functions · System Information Functions And Operators has_table_privilegeFunctionsReferencehas_table_privilege System Information Functions And Operators 10 does user have privilege for table has_table_privilege ( user, table, privilege ) → boolean does user have privilege for tab…Functions · System Information Functions And Operators has_tablespace_privilegeFunctionsReferencehas_tablespace_privilege System Information Functions And Operators 10 does user have privilege for tablespace has_tablespace_privilege ( user, tablespace, privilege ) → boolean does user ha…Functions · System Information Functions And Operators has_type_privilegeFunctionsReferencehas_type_privilege System Information Functions And Operators 10 does user have privilege for type has_type_privilege ( user, type, privilege ) → boolean does user have privilege for type ha…Functions · System Information Functions And Operators hashFunctionsPG18hash ( value [, seed ] ) → integer This is an alias for hash_murmur2. hash(10, 5432) → -5817877081768721676pgbench › Notes › Built-In Functions hash_fnv1aFunctionsPG18hash_fnv1a ( value [, seed ] ) → integer Computes FNV-1a hash. hash_fnv1a(10, 5432) → -7793829335365542153pgbench › Notes › Built-In Functions hash_murmur2FunctionsPG18hash_murmur2 ( value [, seed ] ) → integer Computes MurmurHash2 hash. hash_murmur2(10, 5432) → -5817877081768721676pgbench › Notes › Built-In Functions heightFunctionsReferenceheight Geometric Functions And Operators 10 vertical size of box height ( box ) → double precision vertical size of box 11 12 13 Computes vertical size of box. height ( box ) → double precis…Functions · Geometric Functions And Operators hostFunctionsReferencehost Network Address Functions And Operators 10 extract IP address as text host ( inet ) → text extract IP address as text 11 12 13 Returns the IP address as text, ignoring the netmask. host…Functions · Network Address Functions And Operators hostmaskFunctionsReferencehostmask Network Address Functions And Operators 10 construct host mask for network hostmask ( inet ) → inet construct host mask for network 11 12 13 Computes the host mask for the address's…Functions · Network Address Functions And Operators hstoreFunctionsPG18hstore ( record ) → hstore Constructs an hstore from a record or row. hstore(ROW(1,2)) → "f1"=>"1", "f2"=>"2"hstore — hstore key/value datatype › hstore Operators and Functions hstore_to_arrayFunctionsPG18hstore_to_array ( hstore ) → text[] Extracts an hstore's keys and values as an array of alternating keys and values. hstore_to_array('a=>1,b=>2') → {a,1,b,2}hstore — hstore key/value datatype › hstore Operators and Functions hstore_to_jsonFunctionsPG18hstore_to_json ( hstore ) → json Converts an hstore to a json value, converting all non-null values to JSON strings. This function is used implicitly when an hstore value is cast to json. hs…hstore — hstore key/value datatype › hstore Operators and Functions hstore_to_json_looseFunctionsPG18hstore_to_json_loose ( hstore ) → json Converts an hstore to a json value, but attempts to distinguish numerical and Boolean values so they are unquoted in the JSON. hstore_to_json_loose('"a…hstore — hstore key/value datatype › hstore Operators and Functions hstore_to_jsonbFunctionsPG18hstore_to_jsonb ( hstore ) → jsonb Converts an hstore to a jsonb value, converting all non-null values to JSON strings. This function is used implicitly when an hstore value is cast to jsonb…hstore — hstore key/value datatype › hstore Operators and Functions hstore_to_jsonb_looseFunctionsPG18hstore_to_jsonb_loose ( hstore ) → jsonb Converts an hstore to a jsonb value, but attempts to distinguish numerical and Boolean values so they are unquoted in the JSON. hstore_to_jsonb_loose…hstore — hstore key/value datatype › hstore Operators and Functions hstore_to_matrixFunctionsPG18hstore_to_matrix ( hstore ) → text[] Extracts an hstore's keys and values as a two-dimensional array. hstore_to_matrix('a=>1,b=>2') → {{a,1},{b,2}}hstore — hstore key/value datatype › hstore Operators and Functions icountFunctionsPG18icount ( integer[] ) → integer Returns the number of elements in the array. icount('{1,2,3}'::integer[]) → 3intarray — manipulate arrays of integers › intarray Functions and Operators icu_unicode_versionFunctionsReferenceicu_unicode_version System Information Functions And Operators 17 Returns a string representing the version of Unicode used by ICU, if the server was built with ICU support; otherwise return…Functions · System Information Functions And Operators idxFunctionsPG18idx ( integer[], item integer ) → integer Returns index of the first array element matching item, or 0 if no match. idx(array[11,22,33,22,11], 22) → 2intarray — manipulate arrays of integers › intarray Functions and Operators indexFunctionsPG18index ( a ltree, b ltree ) → integer Returns position of first occurrence of b in a, or -1 if not found. index('0.1.2.3.5.4.5.6.8.5.6.8', '5.6') → 6ltree — hierarchical tree-like data type › Operators and Functions inet_client_addrFunctionsReferenceinet_client_addr System Information Functions And Operators 10 address of the remote connection inet_client_addr ( ) → inet address of the remote connection 11 12 13 Returns the IP address o…Functions · System Information Functions And Operators inet_client_portFunctionsReferenceinet_client_port System Information Functions And Operators 10 port of the remote connection inet_client_port ( ) → int port of the remote connection 11 12 13 Returns the IP port number of t…Functions · System Information Functions And Operators inet_mergeFunctionsReferenceinet_merge Network Address Functions And Operators 10 the smallest network which includes both of the given networks inet_merge ( inet, inet ) → cidr the smallest network which includes both…Functions · Network Address Functions And Operators inet_same_familyFunctionsReferenceinet_same_family Network Address Functions And Operators 10 are the addresses from the same family? inet_same_family ( inet, inet ) → boolean are the addresses from the same family? 11 12 13…Functions · Network Address Functions And Operators inet_server_addrFunctionsReferenceinet_server_addr System Information Functions And Operators 10 address of the local connection inet_server_addr ( ) → inet address of the local connection 11 12 13 Returns the IP address on …Functions · System Information Functions And Operators inet_server_portFunctionsReferenceinet_server_port System Information Functions And Operators 10 port of the local connection inet_server_port ( ) → int port of the local connection 11 12 13 Returns the IP port number on whi…Functions · System Information Functions And Operators initcapFunctionsReferenceinitcap String Functions And Operators 10 Convert the first letter of each word to upper case and the rest to lower case. Words are sequences of alphanumeric characters separated by non-alph…Functions · String Functions And Operators intFunctionsPG18int ( number ) → integer Casts to integer. int(5.4 + 3.8) → 9pgbench › Notes › Built-In Functions intsetFunctionsPG18intset ( integer ) → integer[] Makes a single-element array. intset(42) → {42}intarray — manipulate arrays of integers › intarray Functions and Operators is_validFunctionsPG18is_valid ( isn ) → boolean Checks for the presence of the invalid-check-digit flag.isn — data types for international standard numbers (ISBN, EAN, UPC, etc.) › Functions and Operators isclosedFunctionsReferenceisclosed Geometric Functions And Operators 10 a closed path? isclosed ( path ) → boolean a closed path? 11 12 13 Is path closed? isclosed ( path ) → boolean Is path closed? 14 15 16 17 18 19…Functions · Geometric Functions And Operators isemptyFunctionsReferenceisempty Range/Multirange Functions And Operators 10 is the range empty? isempty ( anyrange ) → boolean is the range empty? 11 12 13 Is the range empty? isempty ( anyrange ) → boolean Is the …Functions · Range/Multirange Functions And Operators isfiniteFunctionsReferenceisfinite Date/Time Functions And Operators 10 Test for finite date (not +/-infinity) isfinite ( date ) → boolean Test for finite date (not +/-infinity) isfinite ( timestamp ) → boolean Test …Functions · Date/Time Functions And Operators isn_weakFunctionsPG18isn_weak ( boolean ) → boolean Sets the weak input mode, and returns the new setting. This function is retained for backward compatibility. The recommended way to set weak mode is via the is…isn — data types for international standard numbers (ISBN, EAN, UPC, etc.) › Functions and Operators isopenFunctionsReferenceisopen Geometric Functions And Operators 10 an open path? isopen ( path ) → boolean an open path? 11 12 13 Is path open? isopen ( path ) → boolean Is path open? 14 15 16 17 18 19 20 9.0 9.1 …Functions · Geometric Functions And Operators jsonFunctionsReferencejson Json Functions And Operators 11 reduce each value in the document, specified by filter to a tsvector, and then concatenate those in document order to produce a single tsvector. filter i…Functions · Json Functions And Operators json_aggFunctionsReferencejson_agg Aggregate Functions 10 aggregates values, including nulls, as a JSON array json_agg ( expression ) → json aggregates values, including nulls, as a JSON array 11 12 13 Collects all t…Functions · Aggregate Functions json_agg_strictFunctionsReferencejson_agg_strict Aggregate Functions 16 Collects all the input values, skipping nulls, into a JSON array. Values are converted to JSON as per to_json or to_jsonb. json_agg_strict ( anyelement…Functions · Aggregate Functions json_arrayFunctionsReferencejson_array Json Functions And Operators 16 Constructs a JSON array from either a series of value_expression parameters or from the results of query_expression, which must be a SELECT query r…Functions · Json Functions And Operators