Functions / Version comparison
What changed?
Functions · PostgreSQL 7.4 → 8.0
Historical documentation for a PostgreSQL version that is no longer supported.
21 added · 1 removed · 9 changed · 0 coverage changes. These are changes between the pinned reference snapshots.
addedceiling
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +ceiling ( dp or numeric ) → (same as input)
removedpow
--- 7.4 +++ 8.0 @@ -1,2 +0,0 @@ -pow ( a dp, b dp ) → dp -pow ( a numeric, b numeric ) → numeric
addedpower
--- 7.4 +++ 8.0 @@ -0,0 +1,2 @@ +power ( a dp, b dp ) → dp +power ( a numeric, b numeric ) → numeric
changedsetseed
--- 7.4 +++ 8.0 @@ -1 +1 @@ -setseed ( dp ) → int32 +setseed ( dp ) → integer
addedwidth_bucket
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +width_bucket ( op numeric, b1 numeric, b2 numeric, count integer ) → integer
changedbtrim
--- 7.4 +++ 8.0 @@ -1,2 +1,2 @@ -btrim ( string text, characters text ) → text -btrim ( string bytea bytes bytea ) → bytea +btrim ( string text [, characters text] ) → text +btrim ( string bytea, bytes bytea ) → bytea
changedlength
--- 7.4 +++ 8.0 @@ -1,2 +1,3 @@ +length ( string text ) → integer length ( string ) → integer length ( object ) → double precision
changedltrim
--- 7.4 +++ 8.0 @@ -1 +1 @@ -ltrim ( string text, characters text ) → text +ltrim ( string text [, characters text] ) → text
changedrepeat
--- 7.4 +++ 8.0 @@ -1 +1 @@ -repeat ( text, integer ) → text +repeat ( string text, number integer ) → text
changedrtrim
--- 7.4 +++ 8.0 @@ -1 +1 @@ -rtrim ( string text, characters text ) → text +rtrim ( string text [, characters text] ) → text
changedto_timestamp
--- 7.4 +++ 8.0 @@ -1 +1 @@ -to_timestamp ( text, text ) → timestamp +to_timestamp ( text, text ) → timestamp with time zone
changedage
--- 7.4 +++ 8.0 @@ -1,2 +1,2 @@ +age ( timestamp, timestamp ) → interval age ( timestamp ) → interval -age ( timestamp, timestamp ) → interval
changedpoint
--- 7.4 +++ 8.0 @@ -1,3 +1,6 @@ +point ( double precision, double precision ) → point +point ( box ) → point point ( circle ) → point +point ( lseg ) → point point ( lseg, lseg ) → point point ( polygon ) → point
addedfamily
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +family ( inet ) → integer
addedbit_and
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +bit_and ( expression ) → same as argument data type
addedbit_or
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +bit_or ( expression ) → same as argument data type
addedbool_and
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +bool_and ( expression ) → bool
addedbool_or
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +bool_or ( expression ) → bool
addedevery
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +every ( expression ) → bool
addedgenerate_series
--- 7.4 +++ 8.0 @@ -0,0 +1,2 @@ +generate_series ( start, stop ) → setof int or setof bigint (same as argument type) +generate_series ( start, stop, step ) → setof int or setof bigint (same as argument type)
addedformat_type
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +format_type ( type_oid, typemod ) → text
addedhas_tablespace_privilege
--- 7.4 +++ 8.0 @@ -0,0 +1,2 @@ +has_tablespace_privilege ( user, tablespace, privilege ) → boolean +has_tablespace_privilege ( tablespace, privilege ) → boolean
addedinet_client_addr
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +inet_client_addr ( ) → inet
addedinet_client_port
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +inet_client_port ( ) → int4
addedinet_server_addr
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +inet_server_addr ( ) → inet
addedinet_server_port
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +inet_server_port ( ) → int4
addedpg_get_serial_sequence
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +pg_get_serial_sequence ( table_name, column_name ) → text
addedpg_tablespace_databases
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +pg_tablespace_databases ( tablespace_oid ) → setof oid
addedpg_cancel_backend
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +pg_cancel_backend ( pid ) → int
addedpg_start_backup
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +pg_start_backup ( label_text ) → text
addedpg_stop_backup
--- 7.4 +++ 8.0 @@ -0,0 +1 @@ +pg_stop_backup ( ) → text