2016-02-08 13:03 GMT+01:00 Marko Tiikkaja <marko(at)joh(dot)to>:
> 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?
>
function see all schema variables from same schema as function's schema
Pavel
>
>
> .m
>