Misc Functions #
All functions are located in the public schema, which is default.
null error(string)
#
Generate an error.
select error("error message");
{"code": 1, "msg": "error message"}
int identity_of(schema, name)
#
Get current serial value of the table identified by
the schema and name.
create table example (id int primary key generated always as identity);
insert into example () values (), (), ();
select * from example;
[[0], [1], [2]]
select identity_of("public", "example");
[3]