SQL Functions

bit.io supports a majority of the built-in functions provided by Postgres outlined here.
For reference, we've provided the Postgres documentation for the most common categories of functions below:

Name

Example Functions

Comparison functions and operators

x <= y
a BETWEEN x AND y

Mathematical functions and operators

5 % 4
log(b numeric, x numeric)

String functions and operators

string || string
substr(string, from [, count])

Date/Time functions and operators

date '2001-09-28' + time '03:00'
current_time

Aggregate Functions

count(expression)
max(expression)

Unsupported built-in Functions

bit.io does not support any system administration functions or functions with the pg_ prefix with the exception of the following:

  • pg_get_expr
  • pg_has_role
  • pg_get_userbyid
  • pg_table_is_visible
  • pg_get_viewdef
  • pg_my_temp_schema
  • pg_is_other_temp_schema
  • pg_encoding_to_char

In addition, the platform does not support the following functions:

  • suppress_redundant_updates_trigger
  • current_setting
  • set_config
  • brin_summarize_new_values
  • brin_summarize_range
  • brin_desummarize_range
  • gin_clean_pending_list
  • current_query
  • inet_client_addr
  • inet_client_port
  • inet_server_addr
  • inet_server_port
  • version
  • row_security_active
  • acldefault
  • aclexplode
  • makeaclitem
  • to_regclass
  • to_regproc
  • to_regprocedure
  • to_regoper
  • to_regoperator
  • to_regtype
  • to_regnamespace
  • to_regrole
  • xmin
  • xmax
  • xip_list
  • table_to_xml
  • query_to_xml
  • cursor_to_xml
  • table_to_xmlschema
  • query_to_xmlschema
  • cursor_to_xmlschema
  • table_to_xml_and_xmlschema
  • query_to_xml_and_xmlschema
  • schema_to_xml
  • schema_to_xmlschema
  • schema_to_xml_and_xmlschema
  • database_to_xml
  • database_to_xmlschema
  • database_to_xml_and_xmlschema

Did this page help you?