Re: proposal: schema PL session variables - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: proposal: schema PL session variables
Date
Msg-id 56B88404.3090308@joh.to
Whole thread Raw
In response to proposal: schema PL session variables  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: proposal: schema PL session variables
List pgsql-hackers
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?


.m



pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: backpatch for REL9_4_STABLE of commit 40482e606733675eb9e5b2f7221186cf81352da1
Next
From: Ashutosh Bapat
Date:
Subject: Re: postgres_fdw join pushdown (was Re: Custom/Foreign-Join-APIs)