Tipos de dados e funções
Funções
• Operadores geométricos: +, -, *, / #, @[email protected], @@, ##, <->, &&, <<, >>, &<, &>, <<|, |>>, &<|, |&>, <^, >^, ?#, ?-, ?|, ?-|,
?-||, @>, <@, ~=
• Funções geométricas: area, center, diameter, height, isclosed, isopen, length, npoint, pclose, popen, radius,
with
• Operadores de rede: <, <=, = >=, >, <>, <<, <<=, >>, >>=, &&, ~, &, |, +, -
• Funções de rede: abbrev, broadcast, family, host, hostmask, masklen, netmask, network, set_masklen, text,
inet_same_family, inet_merge, trunc
• Operadores JSON: ->, ->>, #>, #>>
• Operadores JSONB: @>, <@, ?, ?|, ?&, ||, -, #-, @?, @@
• Funções p/ criação JSON: to_json, array_to_json, row_to_json, json_build_array, json_build_object,
json_obsect
• Funções p/ processar JSON: json_array_lenght, json_each, json_each_text, json_extract_path,
json_extract_path_text, json_object_keys, json_populate_record, json_populate_recordset,
json_array_elements, json_array_elements_text, json_typeof, json_to_record, json_to_recordset,
json_strip_nulls, jsonb_set, jsonb_insert, jsonb_pretty, json_path_exists, jsonb_path_match,
jsonb_path_query, jsonb_path_query_array, jsonb_path_query_first
• Operadores ARRAY: =, <>, <, >, <=, >=, @>, <@, &&, ||
• Funções ARRAY: array_append, array_cat, array_ndims, array_dims, array_fill, array_length, array_lower,
array_position, array_prepend, array_remove, array_replace, array_to_string, array_upper, cardinality,
string_to_array, unnest