[HACKERS] proposal: schema variables
От | Pavel Stehule |
---|---|
Тема | [HACKERS] proposal: schema variables |
Дата | |
Msg-id | CAFj8pRDY+m9OOxfO10R7J0PAkCCauM-TweaTrdsrsLGMb1VbEQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: [HACKERS] proposal: schema variables
(Nico Williams <nico@cryptonector.com>)
Re: [HACKERS] proposal: schema variables (Tatsuo Ishii <ishii@sraoss.co.jp>) Re: [HACKERS] proposal: schema variables ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>) Re: [HACKERS] proposal: schema variables (Gilles Darold <gilles.darold@dalibo.com>) Re: [HACKERS] proposal: schema variables (Chris Travers <chris.travers@adjust.com>) Re: [HACKERS] proposal: schema variables (Mark Dilger <hornschnorter@gmail.com>) Re: [HACKERS] proposal: schema variables (Robert Haas <robertmhaas@gmail.com>) Re: [HACKERS] proposal: schema variables (Craig Ringer <craig@2ndquadrant.com>) Re: [HACKERS] proposal: schema variables (Pavel Golub <pavel@microolap.com>) Re: [HACKERS] proposal: schema variables (Arthur Zakirov <a.zakirov@postgrespro.ru>) |
Список | pgsql-hackers |
Hi,
I propose a new database object - a variable. The variable is persistent object, that holds unshared session based not transactional in memory value of any type. Like variables in any other languages. The persistence is required for possibility to do static checks, but can be limited to session - the variables can be temporal. [ ON TRANSACTION END { RESET | DROP } ]
[ { VOLATILE | STABLE } ];
The variables should be used in queries implicitly (without JOIN)
SELECT varname;
The SEARCH_PATH is used, when varname is located. The variables can be used everywhere where query parameters are allowed.
I hope so this proposal is good enough and simple.
Comments, notes?
regards
Pavel
В списке pgsql-hackers по дате отправления:
Следующее
От: Etsuro FujitaДата:
Сообщение: Re: [HACKERS] Add support for tuple routing to foreign partitions