Search PostgreSQL documentation

txid_snapshot_xipFunctionsReferencetxid_snapshot_xip System Information Functions And Operators 10 get in-progress transaction IDs in snapshot txid_snapshot_xip ( txid_snapshot ) → setof bigint get in-progress transaction IDs…Functions · System Information Functions And Operators txid_snapshot_xmaxFunctionsReferencetxid_snapshot_xmax System Information Functions And Operators 10 get xmax of snapshot txid_snapshot_xmax ( txid_snapshot ) → bigint get xmax of snapshot 11 12 13 See pg_snapshot_xmax(). txid…Functions · System Information Functions And Operators txid_snapshot_xminFunctionsReferencetxid_snapshot_xmin System Information Functions And Operators 10 get xmin of snapshot txid_snapshot_xmin ( txid_snapshot ) → bigint get xmin of snapshot 11 12 13 See pg_snapshot_xmin(). txid…Functions · System Information Functions And Operators txid_statusFunctionsReferencetxid_status System Information Functions And Operators 10 report the status of the given transaction: committed, aborted, in progress, or null if the transaction ID is too old txid_status ( …Functions · System Information Functions And Operators txid_visible_in_snapshotFunctionsReferencetxid_visible_in_snapshot System Information Functions And Operators 10 is transaction ID visible in snapshot? (do not use with subtransaction ids) txid_visible_in_snapshot ( bigint, txid_sna…Functions · System Information Functions And Operators unicode_assignedFunctionsReferenceunicode_assigned String Functions And Operators 17 Returns true if all characters in the string are assigned Unicode codepoints; false otherwise. This function can only be used when the serv…Functions · String Functions And Operators unicode_versionFunctionsReferenceunicode_version System Information Functions And Operators 17 Returns a string representing the version of Unicode used by PostgreSQL. unicode_version () → text Returns a string representing…Functions · System Information Functions And Operators uniqFunctionsPG18uniq ( integer[] ) → integer[] Removes adjacent duplicates. Often used with sort to remove all duplicates. uniq('{1,2,2,3,1,1}'::integer[]) → {1,2,3,1} uniq(sort('{1,2,3,2,1}'::integer[])) →…intarray — manipulate arrays of integers › intarray Functions and Operators unistrFunctionsReferenceunistr String Functions And Operators 14 Evaluate escaped Unicode characters in the argument. Unicode characters can be specified as \XXXX (4 hexadecimal digits), \+XXXXXX (6 hexadecimal dig…Functions · String Functions And Operators unnestFunctionsReferenceunnest Text Search Functions And Operators 10 expand a tsvector to a set of rows unnest ( tsvector, OUT lexeme text, OUT positions smallint[], OUT weights text ) → setof record expand a tsve…Functions · Text Search Functions And Operators upperFunctionsReferenceupper String Functions And Operators 10 Convert string to upper case upper ( string ) → text Convert string to upper case upper ( anyrange ) → range's element type upper bound of range 11 12…Functions · String Functions And Operators upper_incFunctionsReferenceupper_inc Range/Multirange Functions And Operators 10 is the upper bound inclusive? upper_inc ( anyrange ) → boolean is the upper bound inclusive? 11 12 13 Is the range's upper bound inclusi…Functions · Range/Multirange Functions And Operators upper_infFunctionsReferenceupper_inf Range/Multirange Functions And Operators 10 is the upper bound infinite? upper_inf ( anyrange ) → boolean is the upper bound infinite? 11 12 13 Is the range's upper bound infinite?…Functions · Range/Multirange Functions And Operators userFunctionsReferenceuser System Information Functions And Operators 10 equivalent to current_user user → name equivalent to current_user 11 12 13 This is equivalent to current_user. user → name This is equivale…Functions · System Information Functions And Operators uuid_extract_timestampFunctionsReferenceuuid_extract_timestamp Uuid Functions 17 This function extracts a timestamp with time zone from UUID version 1. For other versions, this function returns null. Note that the extracted timest…Functions · Uuid Functions uuid_extract_versionFunctionsReferenceuuid_extract_version Uuid Functions 17 This function extracts the version from a UUID of the variant described by RFC 4122. For other variants, this function returns null. For example, for a…Functions · Uuid Functions uuid_generate_v1FunctionsPG18uuid_generate_v1 () → uuid Generates a version 1 UUID. This involves the MAC address of the computer and a time stamp. Note that UUIDs of this kind reveal the identity of the computer that c…uuid-ossp — a UUID generator › uuid-ossp Functions uuid_generate_v1mcFunctionsPG18uuid_generate_v1mc () → uuid Generates a version 1 UUID, but uses a random multicast MAC address instead of the real MAC address of the computer.uuid-ossp — a UUID generator › uuid-ossp Functions uuid_generate_v3FunctionsPG18uuid_generate_v3 ( namespace uuid, name text ) → uuid Generates a version 3 UUID in the given namespace using the specified input name. The namespace should be one of the special constants p…uuid-ossp — a UUID generator › uuid-ossp Functions uuid_generate_v4FunctionsPG18uuid_generate_v4 () → uuid Generates a version 4 UUID, which is derived entirely from random numbers.uuid-ossp — a UUID generator › uuid-ossp Functions uuid_generate_v5FunctionsPG18uuid_generate_v5 ( namespace uuid, name text ) → uuid Generates a version 5 UUID, which works like a version 3 UUID except that SHA-1 is used as a hashing method. Version 5 should be preferr…uuid-ossp — a UUID generator › uuid-ossp Functions uuid_nilFunctionsPG18uuid_nil () → uuid Returns a “nil” UUID constant, which does not occur as a real UUID.uuid-ossp — a UUID generator › uuid-ossp Functions uuid_ns_dnsFunctionsPG18uuid_ns_dns () → uuid Returns a constant designating the DNS namespace for UUIDs.uuid-ossp — a UUID generator › uuid-ossp Functions uuid_ns_oidFunctionsPG18uuid_ns_oid () → uuid Returns a constant designating the ISO object identifier (OID) namespace for UUIDs. (This pertains to ASN.1 OIDs, which are unrelated to the OIDs used in PostgreSQL.)uuid-ossp — a UUID generator › uuid-ossp Functions uuid_ns_urlFunctionsPG18uuid_ns_url () → uuid Returns a constant designating the URL namespace for UUIDs.uuid-ossp — a UUID generator › uuid-ossp Functions uuid_ns_x500FunctionsPG18uuid_ns_x500 () → uuid Returns a constant designating the X.500 distinguished name (DN) namespace for UUIDs.uuid-ossp — a UUID generator › uuid-ossp Functions uuidv4FunctionsReferenceuuidv4 Uuid Functions 18 Generates a version 4 (random) UUID uuidv4 ( ) → uuid Generates a version 4 (random) UUID 19 20Functions · Uuid Functions uuidv7FunctionsReferenceuuidv7 Uuid Functions 18 Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The option…Functions · Uuid Functions var_popFunctionsReferencevar_pop Aggregate Functions 10 population variance of the input values (square of the population standard deviation) var_pop ( expression ) → double precision for floating-point arguments, o…Functions · Aggregate Functions var_sampFunctionsReferencevar_samp Aggregate Functions 10 sample variance of the input values (square of the sample standard deviation) var_samp ( expression ) → double precision for floating-point arguments, otherwi…Functions · Aggregate Functions varianceFunctionsReferencevariance Aggregate Functions 10 historical alias for var_samp variance ( expression ) → double precision for floating-point arguments, otherwise numeric historical alias for var_samp 11 12 1…Functions · Aggregate Functions versionFunctionsReferenceversion System Information Functions And Operators 10 PostgreSQL version information. See also server_version_num for a machine-readable version. version ( ) → text PostgreSQL version inform…Functions · System Information Functions And Operators websearch_to_tsqueryFunctionsReferencewebsearch_to_tsquery Text Search Functions And Operators 11 produce tsquery from a web search style query websearch_to_tsquery ( [ config regconfig , ] query text ) → tsquery produce tsquery…Functions · Text Search Functions And Operators widthFunctionsReferencewidth Geometric Functions And Operators 10 horizontal size of box width ( box ) → double precision horizontal size of box 11 12 13 Computes horizontal size of box. width ( box ) → double pre…Functions · Geometric Functions And Operators width_bucketFunctionsReferencewidth_bucket Mathematical Functions And Operators 10 return the bucket number to which operand would be assigned in a histogram having count equal-width buckets spanning the range b1 to b2; …Functions · Mathematical Functions And Operators word_similarityFunctionsPG18word_similarity ( text, text ) → real Returns a number that indicates the greatest similarity between the set of trigrams in the first string and any continuous extent of an ordered set of t…pg_trgm — support for similarity of text using trigram matching › Functions and Operators xml_is_well_formedFunctionsReferencexml_is_well_formed Xml Functions 10 These functions check whether a text string is well-formed XML, returning a Boolean result. xml_is_well_formed_document checks for a well-formed document,…Functions · Xml Functions xml_is_well_formed_contentFunctionsReferencexml_is_well_formed_content Xml Functions 10 These functions check whether a text string is well-formed XML, returning a Boolean result. xml_is_well_formed_document checks for a well-formed d…Functions · Xml Functions xml_is_well_formed_documentFunctionsReferencexml_is_well_formed_document Xml Functions 10 These functions check whether a text string is well-formed XML, returning a Boolean result. xml_is_well_formed_document checks for a well-formed …Functions · Xml Functions xml_validFunctionsPG18xml_valid ( document text ) → boolean Parses the given document and returns true if the document is well-formed XML. (Note: this is an alias for the standard PostgreSQL function xml_is_well_…xml2 — XPath querying and XSLT functionality › Description of Functions