Re: proposal: session server side variables

On 28.11.2016 10:42, Pavel Stehule wrote:
>
> next update - setattr, getattr functions are working now
>
> notes, comments?
>
> Regards
>
> Pavel
>

It is interesting!

Do you have plans to support also table variables? For example, like this:

create type composite_type_2 as (a int, b text);
create variable var7 composite_type_2;
select insertvar('var7','(10,Hello world\, Hello world\, Hello world)');
select insertvar('var7','(1000,Hola, hola!)');
select * from getvar('var7');  a   |                   b
------+--------------------------------------- 10   | Hello world, Hello world, Hello world 1000 | Hola, hola!

Or it is a bad idea? Or it is not related to this patch?

We have the extension (https://github.com/postgrespro/pg_variables). And 
it supports table like variables. It shows better performance against 
temporary tables.

-- 
Artur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company