In this SO question about stored procedures in plpgsql
, the stored procedure look like sth.name()
. I don't know what is the meaning of the prefix sth.
For example:
create or replace function something.function_name()
returns setof record as
$$
-- code
$$ language plpgsql;
Looking in this book in the "Part IV: Programming with PostgreSQL" I have found no mention of this type of creation declaration with a function name in two parts.
In the postgresql documentation, at the create function section, the only similar thing is when they deal about argtype
or regtype
than could be written in the form: table_name.column_name%TYPE
. But it's not related to the name of the function.
So, what is this syntax related to ?