On 08/02/16 09:16, Pavel Stehule wrote: Usage ===== DROP SCHEMA IF EXISTS test_schema CASCADE; SET SCHEMA test_schema; CREATE SCHEMA VARIABLE local_counter AS int DEFAULT 0; CREATE OR REPLACE FUNCTION increment_counter() RETURNS void AS $$ BEGIN local_counter := local_counter + 1; END; $$ LANGUAGE plpgsql; How does this function know which schema variables are visible?
Usage ===== DROP SCHEMA IF EXISTS test_schema CASCADE; SET SCHEMA test_schema; CREATE SCHEMA VARIABLE local_counter AS int DEFAULT 0; CREATE OR REPLACE FUNCTION increment_counter() RETURNS void AS $$ BEGIN local_counter := local_counter + 1; END; $$ LANGUAGE plpgsql;
.m
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных