Search PostgreSQL documentation

to_numberFunctionsReferenceto_number Data Type Formatting Functions 10 convert string to numeric to_number ( text, text ) → numeric convert string to numeric 11 12 13 Converts string to numeric according to the given …Functions · Data Type Formatting Functions to_octFunctionsReferenceto_oct String Functions And Operators 17 Converts the number to its equivalent two's complement octal representation. to_oct ( integer ) → text Converts the number to its equivalent two's co…Functions · String Functions And Operators to_regclassFunctionsReferenceto_regclass System Information Functions And Operators 10 get the OID of the named relation to_regclass ( rel_name ) → regclass get the OID of the named relation 11 12 13 Translates a textua…Functions · System Information Functions And Operators to_regcollationFunctionsReferenceto_regcollation System Information Functions And Operators 13 Translates a textual collation name to its OID. A similar result is obtained by casting the string to type regcollation (see Sec…Functions · System Information Functions And Operators to_regdatabaseFunctionsReferenceto_regdatabase System Information Functions And Operators 19 Translates a textual database name to its OID. A similar result is obtained by casting the string to type regdatabase (see Sectio…Functions · System Information Functions And Operators to_regnamespaceFunctionsReferenceto_regnamespace System Information Functions And Operators 10 get the OID of the named schema to_regnamespace ( schema_name ) → regnamespace get the OID of the named schema 11 12 13 Translat…Functions · System Information Functions And Operators to_regoperFunctionsReferenceto_regoper System Information Functions And Operators 10 get the OID of the named operator to_regoper ( operator_name ) → regoper get the OID of the named operator 11 12 13 Translates a text…Functions · System Information Functions And Operators to_regoperatorFunctionsReferenceto_regoperator System Information Functions And Operators 10 get the OID of the named operator to_regoperator ( operator_name ) → regoperator get the OID of the named operator 11 12 13 Trans…Functions · System Information Functions And Operators to_regprocFunctionsReferenceto_regproc System Information Functions And Operators 10 get the OID of the named function to_regproc ( func_name ) → regproc get the OID of the named function 11 12 13 Translates a textual …Functions · System Information Functions And Operators to_regprocedureFunctionsReferenceto_regprocedure System Information Functions And Operators 10 get the OID of the named function to_regprocedure ( func_name ) → regprocedure get the OID of the named function 11 12 13 Transl…Functions · System Information Functions And Operators to_regroleFunctionsReferenceto_regrole System Information Functions And Operators 10 get the OID of the named role to_regrole ( role_name ) → regrole get the OID of the named role 11 12 13 Translates a textual role nam…Functions · System Information Functions And Operators to_regtypeFunctionsReferenceto_regtype System Information Functions And Operators 10 get the OID of the named type to_regtype ( type_name ) → regtype get the OID of the named type 11 12 13 Translates a textual type nam…Functions · System Information Functions And Operators to_regtypemodFunctionsReferenceto_regtypemod System Information Functions And Operators 17 Parses a string of text, extracts a potential type name from it, and translates its type modifier, if any. A syntax error in the s…Functions · System Information Functions And Operators to_timestampFunctionsReferenceto_timestamp Data Type Formatting Functions 10 convert string to time stamp to_timestamp ( text, text ) → timestamp with time zone convert string to time stamp to_timestamp ( double precisio…Functions · Data Type Formatting Functions to_tsqueryFunctionsReferenceto_tsquery Text Search Functions And Operators 10 normalize words and convert to tsquery to_tsquery ( [ config regconfig , ] query text ) → tsquery normalize words and convert to tsquery 11 …Functions · Text Search Functions And Operators to_tsvectorFunctionsReferenceto_tsvector Text Search Functions And Operators 10 reduce document text to tsvector to_tsvector ( [ config regconfig , ] document text ) → tsvector reduce document text to tsvector to_tsvect…Functions · Text Search Functions And Operators transaction_timestampFunctionsReferencetransaction_timestamp Date/Time Functions And Operators 10 Current date and time (start of current transaction); see Section 9.9.4 transaction_timestamp ( ) → timestamp with time zone Curren…Functions · Date/Time Functions And Operators translateFunctionsReferencetranslate String Functions And Operators 10 Any character in string that matches a character in the from set is replaced by the corresponding character in the to set. If from is longer than …Functions · String Functions And Operators trimFunctionsReferencetrim String Functions And Operators 10 Remove the longest string containing only characters from characters (a space by default) from the start, end, or both ends (both is the default) of st…Functions · String Functions And Operators trim_arrayFunctionsReferencetrim_array Array Functions And Operators 14 Trims an array by removing the last n elements. If the array is multidimensional, only the first dimension is trimmed. trim_array ( array anyarray…Functions · Array Functions And Operators trim_scaleFunctionsReferencetrim_scale Mathematical Functions And Operators 13 Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes trim_scale ( numeric ) → numeric Reduces the va…Functions · Mathematical Functions And Operators truncFunctionsReferencetrunc Mathematical Functions And Operators 10 truncate toward zero trunc ( dp or numeric ) → (same as input) truncate toward zero trunc ( v numeric, s int ) → numeric truncate to s decimal p…Functions · Mathematical Functions And Operators ts_debugFunctionsReferencets_debug Text Search Functions And Operators 10 test a configuration ts_debug ( [ config regconfig, ] document text, OUT alias text, OUT description text, OUT token text, OUT dictionaries re…Functions · Text Search Functions And Operators ts_deleteFunctionsReferencets_delete Text Search Functions And Operators 10 remove given lexeme from vector ts_delete ( vector tsvector, lexeme text ) → tsvector remove given lexeme from vector ts_delete ( vector tsve…Functions · Text Search Functions And Operators ts_filterFunctionsReferencets_filter Text Search Functions And Operators 10 select only elements with given weights from vector ts_filter ( vector tsvector, weights "char"[] ) → tsvector select only elements with give…Functions · Text Search Functions And Operators ts_headlineFunctionsReferencets_headline Text Search Functions And Operators 10 display a query match ts_headline ( [ config regconfig, ] document text, query tsquery [, options text ] ) → text display a query match ts_…Functions · Text Search Functions And Operators ts_lexizeFunctionsReferencets_lexize Text Search Functions And Operators 10 test a dictionary ts_lexize ( dict regdictionary, token text ) → text[] test a dictionary 11 12 13 Returns an array of replacement lexemes if…Functions · Text Search Functions And Operators ts_parseFunctionsReferencets_parse Text Search Functions And Operators 10 test a parser ts_parse ( parser_name text, document text, OUT tokid integer, OUT token text ) → setof record test a parser ts_parse ( parser_o…Functions · Text Search Functions And Operators ts_rankFunctionsReferencets_rank Text Search Functions And Operators 10 rank document for query ts_rank ( [ weights float4[], ] vector tsvector, query tsquery [, normalization integer ] ) → float4 rank document for …Functions · Text Search Functions And Operators ts_rank_cdFunctionsReferencets_rank_cd Text Search Functions And Operators 10 rank document for query using cover density ts_rank_cd ( [ weights float4[], ] vector tsvector, query tsquery [, normalization integer ] ) →…Functions · Text Search Functions And Operators ts_rewriteFunctionsReferencets_rewrite Text Search Functions And Operators 10 replace target with substitute within query ts_rewrite ( query tsquery, target tsquery, substitute tsquery ) → tsquery replace target with s…Functions · Text Search Functions And Operators ts_statFunctionsReferencets_stat Text Search Functions And Operators 10 get statistics of a tsvector column ts_stat ( sqlquery text, [ weights text, ] OUT word text, OUT ndoc integer, OUT nentry integer ) → setof re…Functions · Text Search Functions And Operators ts_token_typeFunctionsReferencets_token_type Text Search Functions And Operators 10 get token types defined by parser ts_token_type ( parser_name text, OUT tokid integer, OUT alias text, OUT description text ) → setof rec…Functions · Text Search Functions And Operators tsquery_phraseFunctionsReferencetsquery_phrase Text Search Functions And Operators 10 make query that searches for query1 followed by query2 (same as <-> operator) tsquery_phrase ( query1 tsquery, query2 tsquery ) → tsquer…Functions · Text Search Functions And Operators tsvector_to_arrayFunctionsReferencetsvector_to_array Text Search Functions And Operators 10 convert tsvector to array of lexemes tsvector_to_array ( tsvector ) → text[] convert tsvector to array of lexemes 11 12 13 Converts a…Functions · Text Search Functions And Operators tsvector_update_triggerFunctionsReferencetsvector_update_trigger Trigger Functions 10 trigger function for automatic tsvector column update tsvector_update_trigger ( ) → trigger trigger function for automatic tsvector column update…Functions · Trigger Functions tsvector_update_trigger_columnFunctionsReferencetsvector_update_trigger_column Trigger Functions 10 trigger function for automatic tsvector column update tsvector_update_trigger_column ( ) → trigger trigger function for automatic tsvector…Functions · Trigger Functions txid_currentFunctionsReferencetxid_current System Information Functions And Operators 10 get current transaction ID, assigning a new one if the current transaction does not have one txid_current ( ) → bigint get current …Functions · System Information Functions And Operators txid_current_if_assignedFunctionsReferencetxid_current_if_assigned System Information Functions And Operators 10 same as txid_current() but returns null instead of assigning a new transaction ID if none is already assigned txid_curr…Functions · System Information Functions And Operators txid_current_snapshotFunctionsReferencetxid_current_snapshot System Information Functions And Operators 10 get current snapshot txid_current_snapshot ( ) → txid_snapshot get current snapshot 11 12 13 See pg_current_snapshot(). tx…Functions · System Information Functions And Operators