2016-02-08 13:03 GMT+01:00 Marko Tiikkaja <ma...@joh.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
>

Reply via email to