Built-in Functions and Operators

The following table lists the categories of built-in functions and operators supported by Relyt. All functions and operators are supported in Relyt with the exception of STABLE and VOLATILE functions, which are subject to the restrictions noted in Relyt Function Types. See section Functions and Operators of the PostgreSQL documentation for more information about these built-in functions and operators.

Operator/function category	VOLATILE functions	STABLE functions	Restrictions
Logical operators	N/A	N/A	N/A
Comparison operators	N/A	N/A	N/A
Mathematical functions and operators	random setseed	N/A	N/A
String functions and operators	All built-in conversion functions	convert pg_client_encoding	N/A
Binary string functions and operators	N/A	N/A	N/A
Bit string functions and operators	N/A	N/A	N/A
Pattern matching	N/A	N/A	N/A
Data type formatting functions	N/A	to_char to_timestamp	N/A
Date/time functions and operators	timeofday	age current_date current_time current_timestamp localtime localtimestamp now	N/A
Sequence manipulation functions	nextval() setval()	N/A	N/A
Conditional expressions	N/A	N/A	N/A
Array functions and operators	N/A	All array functions	N/A
Aggregate functions	N/A	N/A	N/A
Subquery expressions	N/A	N/A	N/A
Row and array comparisons	N/A	N/A	N/A
Set returning functions	generate_series	N/A	N/A
System information functions	N/A	All session information functions All access privilege inquiry functions All schema visibility inquiry functions All system catalog information functions All comment information functions All transaction ids and snapshots	N/A
System administration functions	set_config pg_cancel_backend pg_reload_conf pg_rotate_logfile pg_rotate_logfile pg_start_backup pg_size_pretty pg_ls_dir pg_read_file pg_stat_file	current_setting All database object size functions	The function pg_column_size displays bytes required to store the value, possibly with TOAST compression.
XML functions and function-like expressions	N/A	cursor_to_xml(cursor refcursor, count int, nulls boolean, tableforest boolean, targetns text) cursor_to_xmlschema(cursor refcursor, nulls boolean, tableforest boolean, targetns text) database_to_xml(nulls boolean, tableforest boolean, targetns text) database_to_xmlschema(nulls boolean, tableforest boolean, targetns text) database_to_xml_and_xmlschema(nulls boolean, tableforest boolean, targetns text) query_to_xml(query text, nulls boolean, tableforest boolean, targetns text) query_to_xmlschema(query text, nulls boolean, tableforest boolean, targetns text) query_to_xml_and_xmlschema(query text, nulls boolean, tableforest boolean, targetns text) schema_to_xml(schema name, nulls boolean, tableforest boolean, targetns text) schema_to_xmlschema(schema name, nulls boolean, tableforest boolean, targetns text) schema_to_xml_and_xmlschema(schema name, nulls boolean, tableforest boolean, targetns text) table_to_xml(tbl regclass, nulls boolean, tableforest boolean, targetns text) table_to_xmlschema(tbl regclass, nulls boolean, tableforest boolean, targetns text) table_to_xml_and_xmlschema(tbl regclass, nulls boolean, tableforest boolean, targetns text) xmlagg(xml) xmlconcat(xml[, ...]) xmlelement(name name [, xmlattributes(value [AS attname] [, ... ])] [, content, ...]) xmlexists(text, xml) xmlforest(content [AS name] [, ...]) xml_is_well_formed(text) xml_is_well_formed_document(text) xml_is_well_formed_content(text) xmlparse ( { DOCUMENT | CONTENT } value) xpath(text, xml) xpath(text, xml, text[]) xpath_exists(text, xml) path_exists(text, xml, text[]) xmlpi(name target [, content]) xmlroot(xml, version text | no value [, standalone yes|no|no value]) xmlserialize ( { DOCUMENT	CONTENT } value AS type ) xml(text)\text(xml) xmlcomment(xml)\xmlconcat2(xml, xml)