Functions / Version comparison
What changed?
Functions · PostgreSQL 7.3 → 7.4
Historical documentation for a PostgreSQL version that is no longer supported.
15 added · 0 removed · 25 changed · 0 coverage changes. These are changes between the pinned reference snapshots.
changedpow
--- 7.3 +++ 7.4 @@ -1,2 +1,2 @@ -pow ( x dp, e dp ) → dp -pow ( x numeric, e numeric ) → numeric +pow ( a dp, b dp ) → dp +pow ( a numeric, b numeric ) → numeric
addedsetseed
--- 7.3 +++ 7.4 @@ -0,0 +1 @@ +setseed ( dp ) → int32
changedbtrim
--- 7.3 +++ 7.4 @@ -1,2 +1,2 @@ -btrim ( string text, trim text ) → text -btrim ( string bytea trim bytea ) → bytea +btrim ( string text, characters text ) → text +btrim ( string bytea bytes bytea ) → bytea
changedltrim
--- 7.3 +++ 7.4 @@ -1 +1 @@ -ltrim ( string text, text text ) → text +ltrim ( string text, characters text ) → text
addedmd5
--- 7.3 +++ 7.4 @@ -0,0 +1 @@ +md5 ( string text ) → text
changedrtrim
--- 7.3 +++ 7.4 @@ -1 +1 @@ -rtrim ( string text, trim text ) → text +rtrim ( string text, characters text ) → text
changedsplit_part
--- 7.3 +++ 7.4 @@ -1 +1 @@ -split_part ( string text, delimiter text, column integer ) → text +split_part ( string text, delimiter text, field integer ) → text
addedstring_to_array
--- 7.3 +++ 7.4 @@ -0,0 +1 @@ +string_to_array ( text, text ) → text[]
changedtrim
--- 7.3 +++ 7.4 @@ -1,2 +1,2 @@ trim ( [leading | trailing | both] [characters] from string ) → text -trim ( [both] characters from string ) → bytea +trim ( [both] bytes from string ) → bytea
changedbox
--- 7.3 +++ 7.4 @@ -1,4 +1,3 @@ -box ( box, box ) → box box ( circle ) → box box ( point, point ) → box box ( polygon ) → box
addedbox_intersect
--- 7.3 +++ 7.4 @@ -0,0 +1 @@ +box_intersect ( box, box ) → box
addedhostmask
--- 7.3 +++ 7.4 @@ -0,0 +1 @@ +hostmask ( inet ) → inet
changedset_masklen
--- 7.3 +++ 7.4 @@ -1 +1 @@ -set_masklen ( inet,integer ) → inet +set_masklen ( inet, integer ) → inet
changedsetval
--- 7.3 +++ 7.4 @@ -1,2 +1,2 @@ -setval ( text,bigint ) → bigint -setval ( text,bigint,boolean ) → bigint +setval ( text, bigint ) → bigint +setval ( text, bigint, boolean ) → bigint
addedarray_append
--- 7.3 +++ 7.4 @@ -0,0 +1 @@ +array_append ( anyarray, anyelement ) → anyarray
addedarray_cat
--- 7.3 +++ 7.4 @@ -0,0 +1 @@ +array_cat ( anyarray, anyarray ) → anyarray
addedarray_dims
--- 7.3 +++ 7.4 @@ -0,0 +1 @@ +array_dims ( anyarray ) → text
addedarray_lower
--- 7.3 +++ 7.4 @@ -0,0 +1 @@ +array_lower ( anyarray, integer ) → integer
addedarray_prepend
--- 7.3 +++ 7.4 @@ -0,0 +1 @@ +array_prepend ( anyelement, anyarray ) → anyarray
addedarray_to_string
--- 7.3 +++ 7.4 @@ -0,0 +1 @@ +array_to_string ( anyarray, text ) → text
addedarray_upper
--- 7.3 +++ 7.4 @@ -0,0 +1 @@ +array_upper ( anyarray, integer ) → integer
changedcol_description
--- 7.3 +++ 7.4 @@ -1 +1 @@ -col_description ( tableOID, columnnumber ) → text +col_description ( table_oid, column_number ) → text
changedhas_database_privilege
--- 7.3 +++ 7.4 @@ -1,2 +1,2 @@ -has_database_privilege ( user, database, access ) → boolean -has_database_privilege ( database, access ) → boolean +has_database_privilege ( user, database, privilege ) → boolean +has_database_privilege ( database, privilege ) → boolean
changedhas_function_privilege
--- 7.3 +++ 7.4 @@ -1,2 +1,2 @@ -has_function_privilege ( user, function, access ) → boolean -has_function_privilege ( function, access ) → boolean +has_function_privilege ( user, function, privilege ) → boolean +has_function_privilege ( function, privilege ) → boolean
changedhas_language_privilege
--- 7.3 +++ 7.4 @@ -1,2 +1,2 @@ -has_language_privilege ( user, language, access ) → boolean -has_language_privilege ( language, access ) → boolean +has_language_privilege ( user, language, privilege ) → boolean +has_language_privilege ( language, privilege ) → boolean
changedhas_schema_privilege
--- 7.3 +++ 7.4 @@ -1,2 +1,2 @@ -has_schema_privilege ( user, schema, access ) → boolean -has_schema_privilege ( schema, access ) → boolean +has_schema_privilege ( user, schema, privilege ) → boolean +has_schema_privilege ( schema, privilege ) → boolean
changedhas_table_privilege
--- 7.3 +++ 7.4 @@ -1,2 +1,2 @@ -has_table_privilege ( user, table, access ) → boolean -has_table_privilege ( table, access ) → boolean +has_table_privilege ( user, table, privilege ) → boolean +has_table_privilege ( table, privilege ) → boolean
changedobj_description
--- 7.3 +++ 7.4 @@ -1,2 +1,2 @@ -obj_description ( objectOID, tablename ) → text -obj_description ( objectOID ) → text +obj_description ( object_oid, catalog_name ) → text +obj_description ( object_oid ) → text
addedpg_conversion_is_visible
--- 7.3 +++ 7.4 @@ -0,0 +1 @@ +pg_conversion_is_visible ( conversion_oid ) → boolean
changedpg_function_is_visible
--- 7.3 +++ 7.4 @@ -1 +1 @@ -pg_function_is_visible ( functionOID ) → boolean +pg_function_is_visible ( function_oid ) → boolean
changedpg_get_constraintdef
--- 7.3 +++ 7.4 @@ -1 +1,2 @@ -pg_get_constraintdef ( constraintOID ) → text +pg_get_constraintdef ( constraint_oid ) → text +pg_get_constraintdef ( constraint_oid, pretty_bool ) → text
addedpg_get_expr
--- 7.3 +++ 7.4 @@ -0,0 +1,2 @@ +pg_get_expr ( expr_text, relation_oid ) → text +pg_get_expr ( expr_text, relation_oid, pretty_bool ) → text
changedpg_get_indexdef
--- 7.3 +++ 7.4 @@ -1 +1,2 @@ -pg_get_indexdef ( indexOID ) → text +pg_get_indexdef ( index_oid ) → text +pg_get_indexdef ( index_oid, column_no, pretty_bool ) → text
changedpg_get_ruledef
--- 7.3 +++ 7.4 @@ -1 +1,2 @@ -pg_get_ruledef ( ruleOID ) → text +pg_get_ruledef ( rule_oid ) → text +pg_get_ruledef ( rule_oid, pretty_bool ) → text
addedpg_get_triggerdef
--- 7.3 +++ 7.4 @@ -0,0 +1 @@ +pg_get_triggerdef ( trigger_oid ) → text
changedpg_get_viewdef
--- 7.3 +++ 7.4 @@ -1,2 +1,4 @@ -pg_get_viewdef ( viewname ) → text -pg_get_viewdef ( viewOID ) → text +pg_get_viewdef ( view_name ) → text +pg_get_viewdef ( view_name, pretty_bool ) → text +pg_get_viewdef ( view_oid ) → text +pg_get_viewdef ( view_oid, pretty_bool ) → text
changedpg_opclass_is_visible
--- 7.3 +++ 7.4 @@ -1 +1 @@ -pg_opclass_is_visible ( opclassOID ) → boolean +pg_opclass_is_visible ( opclass_oid ) → boolean
changedpg_operator_is_visible
--- 7.3 +++ 7.4 @@ -1 +1 @@ -pg_operator_is_visible ( operatorOID ) → boolean +pg_operator_is_visible ( operator_oid ) → boolean
changedpg_table_is_visible
--- 7.3 +++ 7.4 @@ -1 +1 @@ -pg_table_is_visible ( tableOID ) → boolean +pg_table_is_visible ( table_oid ) → boolean
changedpg_type_is_visible
--- 7.3 +++ 7.4 @@ -1 +1 @@ -pg_type_is_visible ( typeOID ) → boolean +pg_type_is_visible ( type_oid ) → boolean