Search PostgreSQL documentation

cube_subsetFunctionsPG18cube_subset ( cube, integer[] ) → cube Makes a new cube from an existing cube, using a list of dimension indexes from an array. Can be used to extract the endpoints of a single dimension, or…cube — a multi-dimensional cube data type › Usage cube_unionFunctionsPG18cube_union ( cube, cube ) → cube Produces the union of two cubes. cube_union('(1,2)', '(3,4)') → (1, 2),(3, 4)cube — a multi-dimensional cube data type › Usage cube_ur_coordFunctionsPG18cube_ur_coord ( cube, integer ) → float8 Returns the n-th coordinate value for the upper right corner of the cube. cube_ur_coord('(1,2),(3,4)', 2) → 4cube — a multi-dimensional cube data type › Usage cume_distFunctionsReferencecume_dist Aggregate Functions 10 relative rank of the hypothetical row, ranging from 1/N to 1 cume_dist ( args ) WITHIN GROUP (ORDER BY sorted_args) → double precision relative rank of the h…Functions · Aggregate Functions current_catalogFunctionsReferencecurrent_catalog System Information Functions And Operators 10 name of current database (called “catalog” in the SQL standard) current_catalog → name name of current database (called “catalog…Functions · System Information Functions And Operators current_databaseFunctionsReferencecurrent_database System Information Functions And Operators 10 name of current database current_database ( ) → name name of current database 11 12 13 Returns the name of the current database…Functions · System Information Functions And Operators current_dateFunctionsReferencecurrent_date Date/Time Functions And Operators 10 Current date; see Section 9.9.4 current_date → date Current date; see Section 9.9.4 11 12 13 14 Current date; see Section 9.9.5 current_date…Functions · Date/Time Functions And Operators current_queryFunctionsReferencecurrent_query System Information Functions And Operators 10 text of the currently executing query, as submitted by the client (might contain more than one statement) current_query ( ) → text…Functions · System Information Functions And Operators current_roleFunctionsReferencecurrent_role System Information Functions And Operators 10 equivalent to current_user current_role → name equivalent to current_user 11 12 13 This is equivalent to current_user. current_role…Functions · System Information Functions And Operators current_schemaFunctionsReferencecurrent_schema System Information Functions And Operators 10 name of current schema current_schema → name name of current schema 11 12 13 Returns the name of the schema that is first in the …Functions · System Information Functions And Operators current_schemasFunctionsReferencecurrent_schemas System Information Functions And Operators 10 names of schemas in search path, optionally including implicit schemas current_schemas ( boolean ) → name[] names of schemas in …Functions · System Information Functions And Operators current_settingFunctionsReferencecurrent_setting System Administration Functions 10 get current value of setting current_setting ( setting_name [, missing_ok ] ) → text get current value of setting 11 12 13 Returns the curr…Functions · System Administration Functions current_timeFunctionsReferencecurrent_time Date/Time Functions And Operators 10 Current time of day; see Section 9.9.4 current_time → time with time zone Current time of day; see Section 9.9.4 CURRENT_TIME(precision) CUR…Functions · Date/Time Functions And Operators current_timestampFunctionsReferencecurrent_timestamp Date/Time Functions And Operators 10 Current date and time (start of current transaction); see Section 9.9.4 current_timestamp → timestamp with time zone Current date and t…Functions · Date/Time Functions And Operators current_userFunctionsReferencecurrent_user System Information Functions And Operators 10 user name of current execution context current_user → name user name of current execution context 11 12 13 Returns the user name of…Functions · System Information Functions And Operators currvalFunctionsReferencecurrval Sequence Manipulation Functions 10 Return value most recently obtained with nextval for specified sequence currval ( regclass ) → bigint Return value most recently obtained with next…Functions · Sequence Manipulation Functions cursor_to_xmlFunctionsReferencecursor_to_xml Xml Functions 10 The return type of each function is xml. cursor_to_xml(cursor refcursor, count int, nulls boolean, tableforest boolean, targetns text) The return type of each …Functions · Xml Functions cursor_to_xmlschemaFunctionsReferencecursor_to_xmlschema Xml Functions 10 It is essential that the same parameters are passed in order to obtain matching XML data mappings and XML Schema documents. cursor_to_xmlschema(cursor re…Functions · Xml Functions database_to_xmlFunctionsReferencedatabase_to_xml Xml Functions 10 Note that these potentially produce a lot of data, which needs to be built up in memory. When requesting content mappings of large schemas or databases, it m…Functions · Xml Functions database_to_xml_and_xmlschemaFunctionsReferencedatabase_to_xml_and_xmlschema Xml Functions 10 Note that these potentially produce a lot of data, which needs to be built up in memory. When requesting content mappings of large schemas or d…Functions · Xml Functions database_to_xmlschemaFunctionsReferencedatabase_to_xmlschema Xml Functions 10 Note that these potentially produce a lot of data, which needs to be built up in memory. When requesting content mappings of large schemas or databases…Functions · Xml Functions date_addFunctionsReferencedate_add Date/Time Functions And Operators 16 Add an interval to a timestamp with time zone, computing times of day and daylight-savings adjustments according to the time zone named by the t…Functions · Date/Time Functions And Operators date_binFunctionsReferencedate_bin Date/Time Functions And Operators 14 Bin input into specified interval aligned with specified origin; see Section 9.9.3 date_bin ( interval, timestamp, timestamp ) → timestamp Bin i…Functions · Date/Time Functions And Operators date_partFunctionsReferencedate_part Date/Time Functions And Operators 10 Get subfield (equivalent to extract); see Section 9.9.1 date_part ( text, timestamp ) → double precision Get subfield (equivalent to extract); …Functions · Date/Time Functions And Operators date_subtractFunctionsReferencedate_subtract Date/Time Functions And Operators 16 Subtract an interval from a timestamp with time zone, computing times of day and daylight-savings adjustments according to the time zone na…Functions · Date/Time Functions And Operators date_truncFunctionsReferencedate_trunc Date/Time Functions And Operators 10 Truncate to specified precision; see also Section 9.9.2 date_trunc ( text, timestamp ) → timestamp Truncate to specified precision; see also S…Functions · Date/Time Functions And Operators debugFunctionsPG18debug ( number ) → same type as input Prints the argument to stderr, and returns the argument. debug(5432.1) → 5432.1pgbench › Notes › Built-In Functions decodeFunctionsReferencedecode Binary String Functions And Operators 10 Decode binary data from textual representation in string. Options for format are same as in encode. decode ( string text, format text ) → byte…Functions · Binary String Functions And Operators definedFunctionsPG18defined ( hstore, text ) → boolean Does hstore contain a non-NULL value for key? defined('a=>NULL', 'a') → fhstore — hstore key/value datatype › hstore Operators and Functions degreesFunctionsReferencedegrees Mathematical Functions And Operators 10 radians to degrees degrees ( dp ) → dp radians to degrees 11 12 13 Converts radians to degrees degrees ( double precision ) → double precision…Functions · Mathematical Functions And Operators deleteFunctionsPG18delete ( hstore, text ) → hstore Deletes pair with matching key. delete('a=>1,b=>2', 'b') → "a"=>"1"hstore — hstore key/value datatype › hstore Operators and Functions dense_rankFunctionsReferencedense_rank Aggregate Functions 10 rank of the hypothetical row, without gaps dense_rank ( args ) WITHIN GROUP (ORDER BY sorted_args) → bigint rank of the hypothetical row, without gaps dense…Functions · Aggregate Functions diagonalFunctionsReferencediagonal Geometric Functions And Operators 13 Extracts box's diagonal as a line segment (same as lseg(box)). diagonal ( box ) → lseg Extracts box's diagonal as a line segment (same as lseg(b…Functions · Geometric Functions And Operators diameterFunctionsReferencediameter Geometric Functions And Operators 10 diameter of circle diameter ( circle ) → double precision diameter of circle 11 12 13 Computes diameter of circle. diameter ( circle ) → double …Functions · Geometric Functions And Operators divFunctionsReferencediv Mathematical Functions And Operators 10 integer quotient of y/x div ( y numeric, x numeric ) → numeric integer quotient of y/x 11 12 13 Integer quotient of y/x (truncates towards zero) d…Functions · Mathematical Functions And Operators doubleFunctionsPG18double ( number ) → double Casts to double. double(5432) → 5432.0pgbench › Notes › Built-In Functions eachFunctionsPG18each ( hstore ) → setof record ( key text, value text ) Extracts an hstore's keys and values as a set of records. select * from each('a=>1,b=>2') → key | value -----+------- a | 1 b | 2hstore — hstore key/value datatype › hstore Operators and Functions earthFunctionsPG18earth () → float8 Returns the assumed radius of the Earth.earthdistance — calculate great-circle distances › Cube-Based Earth Distances earth_boxFunctionsPG18earth_box ( earth, float8 ) → cube Returns a box suitable for an indexed search using the cube @> operator for points within a given great circle distance of a location. Some points in this …earthdistance — calculate great-circle distances › Cube-Based Earth Distances earth_distanceFunctionsPG18earth_distance ( earth, earth ) → float8 Returns the great circle distance between two points on the surface of the Earth.earthdistance — calculate great-circle distances › Cube-Based Earth Distances