Re: proposal: session server side variables

From: Artur Zakirov <a(dot)zakirov(at)postgrespro(dot)ru>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: proposal: session server side variables
Date: 2016-11-28 09:39:54
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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 ( And
it supports table like variables. It shows better performance against
temporary tables.

Artur Zakirov
Postgres Professional:
Russian Postgres Company

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2016-11-28 10:13:50 Re: IF (NOT) EXISTS in psql-completion
Previous Message Dilip Kumar 2016-11-28 09:32:37 Re: Proposal: scan key push down to heap [WIP]