Functions / Version comparison
What changed?
Functions · PostgreSQL 8.0 → 8.1
Historical documentation for a PostgreSQL version that is no longer supported.
19 added · 1 removed · 45 changed · 0 coverage changes. These are changes between the pinned reference snapshots.
changedround
--- 8.0 +++ 8.1 @@ -1,2 +1,2 @@ round ( dp or numeric ) → (same as input) -round ( v numeric, s integer ) → numeric +round ( v numeric, s int ) → numeric
changedsetseed
--- 8.0 +++ 8.1 @@ -1 +1 @@ -setseed ( dp ) → integer +setseed ( dp ) → int
changedtrunc
--- 8.0 +++ 8.1 @@ -1,3 +1,3 @@ trunc ( dp or numeric ) → (same as input) -trunc ( v numeric, s integer ) → numeric +trunc ( v numeric, s int ) → numeric trunc ( macaddr ) → macaddr
changedwidth_bucket
--- 8.0 +++ 8.1 @@ -1 +1 @@ -width_bucket ( op numeric, b1 numeric, b2 numeric, count integer ) → integer +width_bucket ( op numeric, b1 numeric, b2 numeric, count int ) → int
changedascii
--- 8.0 +++ 8.1 @@ -1 +1 @@ -ascii ( text ) → integer +ascii ( text ) → int
changedbit_length
--- 8.0 +++ 8.1 @@ -1 +1 @@ -bit_length ( string ) → integer +bit_length ( string ) → int
changedchar_length
--- 8.0 +++ 8.1 @@ -1 +1 @@ -char_length ( string ) → integer +char_length ( string ) → int
changedcharacter_length
--- 8.0 +++ 8.1 @@ -1 +1 @@ -character_length ( string ) → integer +character_length ( string ) → int
changedchr
--- 8.0 +++ 8.1 @@ -1 +1 @@ -chr ( integer ) → text +chr ( int ) → text
changedlength
--- 8.0 +++ 8.1 @@ -1,3 +1,3 @@ -length ( string text ) → integer -length ( string ) → integer +length ( string text ) → int +length ( string ) → int length ( object ) → double precision
changedlpad
--- 8.0 +++ 8.1 @@ -1 +1 @@ -lpad ( string text, length integer [, fill text] ) → text +lpad ( string text, length int [, fill text] ) → text
changedmd5
--- 8.0 +++ 8.1 @@ -1 +1,2 @@ md5 ( string text ) → text +md5 ( string ) → text
changedoctet_length
--- 8.0 +++ 8.1 @@ -1 +1 @@ -octet_length ( string ) → integer +octet_length ( string ) → int
changedoverlay
--- 8.0 +++ 8.1 @@ -1 +1 @@ -overlay ( string placing string from integer [for integer] ) → text +overlay ( string placing string from int [for int] ) → text
changedposition
--- 8.0 +++ 8.1 @@ -1 +1 @@ -position ( substring in string ) → integer +position ( substring in string ) → int
addedregexp_replace
--- 8.0 +++ 8.1 @@ -0,0 +1 @@ +regexp_replace ( string text, pattern text, replacement text [,flags text] ) → text
changedrepeat
--- 8.0 +++ 8.1 @@ -1 +1 @@ -repeat ( string text, number integer ) → text +repeat ( string text, number int ) → text
changedrpad
--- 8.0 +++ 8.1 @@ -1 +1 @@ -rpad ( string text, length integer [, fill text] ) → text +rpad ( string text, length int [, fill text] ) → text
changedsplit_part
--- 8.0 +++ 8.1 @@ -1 +1 @@ -split_part ( string text, delimiter text, field integer ) → text +split_part ( string text, delimiter text, field int ) → text
changedsubstring
--- 8.0 +++ 8.1 @@ -1,4 +1,4 @@ -substring ( string [from integer] [for integer] ) → text +substring ( string [from int] [for int] ) → text substring ( string from pattern ) → text substring ( string from pattern for escape ) → text -substring ( string [from integer] [for integer] ) → bytea +substring ( string [from int] [for int] ) → bytea
changedto_hex
--- 8.0 +++ 8.1 @@ -1 +1 @@ -to_hex ( number integer or bigint ) → text +to_hex ( number int or bigint ) → text
changedget_bit
--- 8.0 +++ 8.1 @@ -1 +1 @@ -get_bit ( string, offset ) → integer +get_bit ( string, offset ) → int
changedget_byte
--- 8.0 +++ 8.1 @@ -1 +1 @@ -get_byte ( string, offset ) → integer +get_byte ( string, offset ) → int
changedto_timestamp
--- 8.0 +++ 8.1 @@ -1 +1,2 @@ to_timestamp ( text, text ) → timestamp with time zone +to_timestamp ( double precision ) → timestamp with time zone
changedcurrent_time
--- 8.0 +++ 8.1 @@ -1,2 +1,2 @@ current_time → time with time zone -CURRENT_TIME ( precision ) +CURRENT_TIME (precision)
changedcurrent_timestamp
--- 8.0 +++ 8.1 @@ -1,2 +1,2 @@ current_timestamp → timestamp with time zone -CURRENT_TIMESTAMP ( precision ) LOCALTIME LOCALTIMESTAMP +CURRENT_TIMESTAMP (precision) LOCALTIME LOCALTIMESTAMP
changedextract
--- 8.0 +++ 8.1 @@ -1,3 +1,3 @@ extract ( field from timestamp ) → double precision extract ( field from interval ) → double precision -EXTRACT (field FROM source) +EXTRACT(field FROM source)
addedjustify_days
--- 8.0 +++ 8.1 @@ -0,0 +1 @@ +justify_days ( interval ) → interval
addedjustify_hours
--- 8.0 +++ 8.1 @@ -0,0 +1 @@ +justify_hours ( interval ) → interval
changedlocaltime
--- 8.0 +++ 8.1 @@ -1,2 +1,2 @@ localtime → time -LOCALTIME ( precision ) +LOCALTIME (precision)
changedlocaltimestamp
--- 8.0 +++ 8.1 @@ -1,2 +1,2 @@ localtimestamp → timestamp -LOCALTIMESTAMP ( precision ) +LOCALTIMESTAMP (precision)
removedbox_intersect
--- 8.0 +++ 8.1 @@ -1 +0,0 @@ -box_intersect ( box, box ) → box
changedcircle
--- 8.0 +++ 8.1 @@ -1,2 +1,3 @@ circle ( box ) → circle circle ( point, double precision ) → circle +circle ( polygon ) → circle
changednpoints
--- 8.0 +++ 8.1 @@ -1,2 +1,2 @@ -npoints ( path ) → integer -npoints ( polygon ) → integer +npoints ( path ) → int +npoints ( polygon ) → int
changedpoint
--- 8.0 +++ 8.1 @@ -2,5 +2,4 @@ point ( box ) → point point ( circle ) → point point ( lseg ) → point -point ( lseg, lseg ) → point point ( polygon ) → point
changedfamily
--- 8.0 +++ 8.1 @@ -1 +1 @@ -family ( inet ) → integer +family ( inet ) → int
changedmasklen
--- 8.0 +++ 8.1 @@ -1 +1 @@ -masklen ( inet ) → integer +masklen ( inet ) → int
changedset_masklen
--- 8.0 +++ 8.1 @@ -1 +1 @@ -set_masklen ( inet, integer ) → inet +set_masklen ( inet, int ) → inet
changedcurrval
--- 8.0 +++ 8.1 @@ -1 +1 @@ -currval ( text ) → bigint +currval ( regclass ) → bigint
addedlastval
--- 8.0 +++ 8.1 @@ -0,0 +1 @@ +lastval ( ) → bigint
changednextval
--- 8.0 +++ 8.1 @@ -1 +1 @@ -nextval ( text ) → bigint +nextval ( regclass ) → bigint
changedsetval
--- 8.0 +++ 8.1 @@ -1,2 +1,2 @@ -setval ( text, bigint ) → bigint -setval ( text, bigint, boolean ) → bigint +setval ( regclass, bigint ) → bigint +setval ( regclass, bigint, boolean ) → bigint
addedGREATEST
--- 8.0 +++ 8.1 @@ -0,0 +1 @@ +GREATEST(value [, ...])
addedLEAST
--- 8.0 +++ 8.1 @@ -0,0 +1 @@ +LEAST(value [, ...])
changedarray_lower
--- 8.0 +++ 8.1 @@ -1 +1 @@ -array_lower ( anyarray, integer ) → integer +array_lower ( anyarray, int ) → int
changedarray_upper
--- 8.0 +++ 8.1 @@ -1 +1 @@ -array_upper ( anyarray, integer ) → integer +array_upper ( anyarray, int ) → int
changedsum
--- 8.0 +++ 8.1 @@ -1 +1 @@ -sum ( expression ) → bigint for smallint or integer arguments, numeric for bigint arguments, double precision for floating-point arguments, otherwise the same as the argument data type +sum ( expression ) → bigint for smallint or int arguments, numeric for bigint arguments, double precision for floating-point arguments, otherwise the same as the argument data type
changedinet_client_port
--- 8.0 +++ 8.1 @@ -1 +1 @@ -inet_client_port ( ) → int4 +inet_client_port ( ) → int
changedinet_server_port
--- 8.0 +++ 8.1 @@ -1 +1 @@ -inet_server_port ( ) → int4 +inet_server_port ( ) → int
changedpg_get_userbyid
--- 8.0 +++ 8.1 @@ -1 +1 @@ -pg_get_userbyid ( userid ) → name +pg_get_userbyid ( roleid ) → name
addedpg_has_role
--- 8.0 +++ 8.1 @@ -0,0 +1,2 @@ +pg_has_role ( user, role, privilege ) → boolean +pg_has_role ( role, privilege ) → boolean
addedpg_postmaster_start_time
--- 8.0 +++ 8.1 @@ -0,0 +1 @@ +pg_postmaster_start_time ( ) → timestamp with time zone
changedpg_cancel_backend
--- 8.0 +++ 8.1 @@ -1 +1 @@ -pg_cancel_backend ( pid ) → int +pg_cancel_backend ( pid int ) → boolean
addedpg_column_size
--- 8.0 +++ 8.1 @@ -0,0 +1 @@ +pg_column_size ( any ) → int
addedpg_database_size
--- 8.0 +++ 8.1 @@ -0,0 +1,2 @@ +pg_database_size ( oid ) → bigint +pg_database_size ( name ) → bigint
addedpg_ls_dir
--- 8.0 +++ 8.1 @@ -0,0 +1 @@ +pg_ls_dir ( dirname text ) → setof text
addedpg_read_file
--- 8.0 +++ 8.1 @@ -0,0 +1 @@ +pg_read_file ( filename text, offset bigint, length bigint ) → text
addedpg_relation_size
--- 8.0 +++ 8.1 @@ -0,0 +1,2 @@ +pg_relation_size ( oid ) → bigint +pg_relation_size ( text ) → bigint
addedpg_reload_conf
--- 8.0 +++ 8.1 @@ -0,0 +1 @@ +pg_reload_conf ( ) → boolean
addedpg_rotate_logfile
--- 8.0 +++ 8.1 @@ -0,0 +1 @@ +pg_rotate_logfile ( ) → boolean
addedpg_size_pretty
--- 8.0 +++ 8.1 @@ -0,0 +1 @@ +pg_size_pretty ( bigint ) → text
changedpg_start_backup
--- 8.0 +++ 8.1 @@ -1 +1 @@ -pg_start_backup ( label_text ) → text +pg_start_backup ( label text ) → text
addedpg_stat_file
--- 8.0 +++ 8.1 @@ -0,0 +1 @@ +pg_stat_file ( filename text ) → record
addedpg_tablespace_size
--- 8.0 +++ 8.1 @@ -0,0 +1,2 @@ +pg_tablespace_size ( oid ) → bigint +pg_tablespace_size ( name ) → bigint
addedpg_total_relation_size
--- 8.0 +++ 8.1 @@ -0,0 +1,2 @@ +pg_total_relation_size ( oid ) → bigint +pg_total_relation_size ( text ) → bigint