Functions / Version comparison
What changed?
Functions · PostgreSQL 8.2 → 8.3
Historical documentation for a PostgreSQL version that is no longer supported.
59 added · 0 removed · 10 changed · 0 coverage changes. These are changes between the pinned reference snapshots.
changedatan2
--- 8.2 +++ 8.3 @@ -1 +1 @@ -atan2 ( x, y ) +atan2 ( y, x )
changedsetseed
--- 8.2 +++ 8.3 @@ -1 +1 @@ -setseed ( dp ) → int +setseed ( dp ) → void
changedwidth_bucket
--- 8.2 +++ 8.3 @@ -1 +1,2 @@ width_bucket ( op numeric, b1 numeric, b2 numeric, count int ) → int +width_bucket ( op dp, b1 dp, b2 dp, count int ) → int
changedlength
--- 8.2 +++ 8.3 @@ -1,2 +1,4 @@ length ( string ) → int +length ( stringbytea, encoding name ) → int length ( object ) → double precision +length ( tsvector ) → integer
changedquote_ident
--- 8.2 +++ 8.3 @@ -1 +1 @@ -quote_ident ( string ) → text +quote_ident ( string text ) → text
changedquote_literal
--- 8.2 +++ 8.3 @@ -1 +1,2 @@ -quote_literal ( string ) → text +quote_literal ( string text ) → text +quote_literal ( value anyelement ) → text
addedregexp_matches
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +regexp_matches ( string text, pattern text [, flags text] ) → setof text[]
changedregexp_replace
--- 8.2 +++ 8.3 @@ -1 +1 @@ -regexp_replace ( string text, pattern text, replacement text [,flags text] ) → text +regexp_replace ( string text, pattern text, replacement text [, flags text] ) → text
addedregexp_split_to_array
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +regexp_split_to_array ( string text, pattern text [, flags text ] ) → text[]
addedregexp_split_to_table
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +regexp_split_to_table ( string text, pattern text [, flags text] ) → setof text
changedconvert
--- 8.2 +++ 8.3 @@ -1,2 +1 @@ -convert ( string using conversion_name ) → text -convert ( string text, [src_encoding name,] dest_encoding name ) → text +convert ( string bytea, src_encoding name, dest_encoding name ) → bytea
addedconvert_from
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +convert_from ( string bytea, src_encoding name ) → text
addedconvert_to
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +convert_to ( string text, dest_encoding name ) → bytea
addedenum_first
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +enum_first ( anyenum )
addedenum_last
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +enum_last ( anyenum )
addedenum_range
--- 8.2 +++ 8.3 @@ -0,0 +1,4 @@ +enum_range ( anyenum ) +enum_range ( anyenum, anyenum ) +enum_range ( NULL, 'green'::rainbow ) +enum_range ( 'orange'::rainbow, NULL )
changedpath
--- 8.2 +++ 8.3 @@ -1 +1 @@ -path ( polygon ) → point +path ( polygon ) → path
addedget_current_ts_config
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +get_current_ts_config ( ) → regconfig
addednumnode
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +numnode ( tsquery ) → integer
addedplainto_tsquery
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +plainto_tsquery ( [ config regconfig , ] query text ) → tsquery
addedquerytree
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +querytree ( query tsquery ) → text
addedsetweight
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +setweight ( tsvector, "char" ) → tsvector
addedstrip
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +strip ( tsvector ) → tsvector
addedto_tsquery
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +to_tsquery ( [ config regconfig , ] query text ) → tsquery
addedto_tsvector
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +to_tsvector ( [ config regconfig , ] document text ) → tsvector
addedts_debug
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +ts_debug ( [ config regconfig, ] document text, OUT alias text, OUT description text, OUT token text, OUT dictionaries regdictionary[], OUT dictionary regdictionary, OUT lexemes text[] ) → setof record
addedts_headline
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +ts_headline ( [ config regconfig, ] document text, query tsquery [, options text ] ) → text
addedts_lexize
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +ts_lexize ( dict regdictionary, token text ) → text[]
addedts_parse
--- 8.2 +++ 8.3 @@ -0,0 +1,2 @@ +ts_parse ( parser_name text, document text, OUT tokid integer, OUT token text ) → setof record +ts_parse ( parser_oid oid, document text, OUT tokid integer, OUT token text ) → setof record
addedts_rank
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +ts_rank ( [ weights float4[], ] vector tsvector, query tsquery [, normalization integer ] ) → float4
addedts_rank_cd
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +ts_rank_cd ( [ weights float4[], ] vector tsvector, query tsquery [, normalization integer ] ) → float4
addedts_rewrite
--- 8.2 +++ 8.3 @@ -0,0 +1,2 @@ +ts_rewrite ( query tsquery, target tsquery, substitute tsquery ) → tsquery +ts_rewrite ( query tsquery, select text ) → tsquery
addedts_stat
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +ts_stat ( sqlquery text, [ weights text, ] OUT word text, OUT ndoc integer, OUT nentry integer ) → setof record
addedts_token_type
--- 8.2 +++ 8.3 @@ -0,0 +1,2 @@ +ts_token_type ( parser_name text, OUT tokid integer, OUT alias text, OUT description text ) → setof record +ts_token_type ( parser_oid oid, OUT tokid integer, OUT alias text, OUT description text ) → setof record
addedcursor_to_xml
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +cursor_to_xml(cursor refcursor, count int, nulls boolean, tableforest boolean, targetns text)
addedcursor_to_xmlschema
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +cursor_to_xmlschema(cursor refcursor, nulls boolean, tableforest boolean, targetns text)
addeddatabase_to_xml
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +database_to_xml(nulls boolean, tableforest boolean, targetns text)
addeddatabase_to_xml_and_xmlschema
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +database_to_xml_and_xmlschema(nulls boolean, tableforest boolean, targetns text)
addeddatabase_to_xmlschema
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +database_to_xmlschema(nulls boolean, tableforest boolean, targetns text)
addedquery_to_xml
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +query_to_xml(query text, nulls boolean, tableforest boolean, targetns text)
addedquery_to_xml_and_xmlschema
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +query_to_xml_and_xmlschema(query text, nulls boolean, tableforest boolean, targetns text)
addedquery_to_xmlschema
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +query_to_xmlschema(query text, nulls boolean, tableforest boolean, targetns text)
addedschema_to_xml
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +schema_to_xml(schema name, nulls boolean, tableforest boolean, targetns text)
addedschema_to_xml_and_xmlschema
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +schema_to_xml_and_xmlschema(schema name, nulls boolean, tableforest boolean, targetns text)
addedschema_to_xmlschema
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +schema_to_xmlschema(schema name, nulls boolean, tableforest boolean, targetns text)
addedtable_to_xml
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +table_to_xml(tbl regclass, nulls boolean, tableforest boolean, targetns text)
addedtable_to_xml_and_xmlschema
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +table_to_xml_and_xmlschema(tbl regclass, nulls boolean, tableforest boolean, targetns text)
addedtable_to_xmlschema
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +table_to_xmlschema(tbl regclass, nulls boolean, tableforest boolean, targetns text)
addedxmlagg
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +xmlagg(xml)
addedxmlcomment
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +xmlcomment(text)
addedxmlconcat
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +xmlconcat(xml[, ...])
addedxmlelement
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +xmlelement(name name [, xmlattributes(value [AS attname] [, ... ])] [, content, ...])
addedxmlforest
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +xmlforest(content [AS name] [, ...])
addedxmlpi
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +xmlpi(name target [, content])
addedxmlroot
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +xmlroot(xml, version text|no value [, standalone yes|no|no value])
addedxpath
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +xpath(xpath, xml[, nsarray])
changedlastval
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +lastval ( ) → bigint
addedpg_ts_config_is_visible
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +pg_ts_config_is_visible ( config_oid ) → boolean
addedpg_ts_dict_is_visible
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +pg_ts_dict_is_visible ( dict_oid ) → boolean
addedpg_ts_parser_is_visible
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +pg_ts_parser_is_visible ( parser_oid ) → boolean
addedpg_ts_template_is_visible
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +pg_ts_template_is_visible ( template_oid ) → boolean
addedtxid_current
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +txid_current ( ) → bigint
addedtxid_current_snapshot
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +txid_current_snapshot ( ) → txid_snapshot
addedtxid_snapshot_xip
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +txid_snapshot_xip ( txid_snapshot ) → setof bigint
addedtxid_snapshot_xmax
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +txid_snapshot_xmax ( txid_snapshot ) → bigint
addedtxid_snapshot_xmin
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +txid_snapshot_xmin ( txid_snapshot ) → bigint
addedtxid_visible_in_snapshot
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +txid_visible_in_snapshot ( bigint, txid_snapshot ) → boolean
addedtsvector_update_trigger
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +tsvector_update_trigger ( ) → trigger
addedtsvector_update_trigger_column
--- 8.2 +++ 8.3 @@ -0,0 +1 @@ +tsvector_update_trigger_column ( ) → trigger