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

From Pavel Stehule
Subject Re: proposal: schema PL session variables
Date
Msg-id CAFj8pRDx3usUcz8uAgXs_3v6OOsmfNPtgmVeXGu9=pTnioR_zw@mail.gmail.com
Whole thread Raw
In response to Re: proposal: schema PL session variables  (Marko Tiikkaja <marko@joh.to>)
Responses Re: proposal: schema PL session variables
List pgsql-hackers


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

pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: postgres_fdw join pushdown (was Re: Custom/Foreign-Join-APIs)
Next
From: Marko Tiikkaja
Date:
Subject: Re: proposal: schema PL session variables