sql.first_free_doc_id.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of postgresql Show documentation

PostgreSQL implementation of a ToroDB backend. This was the original backend implemented in ToroDB, and is also considered as the default ToroDB backend and a reference implementation.

The newest version!

CREATE OR REPLACE FUNCTION torodb.first_free_doc_id(col_schema varchar)
RETURNS integer AS $$
DECLARE
    seq_name varchar := '"' || col_schema || '".root_seq';
BEGIN
    return nextval(seq_name);
END;
$$ LANGUAGE plpgsql;