[Feature request] variable declaration of anonymous composite data type in PL/pgSQL

Поиск
Список
Период
Сортировка
От Maciej Mrozowski
Тема [Feature request] variable declaration of anonymous composite data type in PL/pgSQL
Дата
Msg-id 201003020008.32101.reavertm@gmail.com
обсуждение исходный текст
Ответы Re: [Feature request] variable declaration of anonymous composite data type in PL/pgSQL  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Hello,

Not sure whether it's appropriate list for feature requests though..
Would it be suitable to implement such variable declarations in PL/pgSQL so 
that following (or similar) constructs would be possible?

DECLAREtmpStruct (name varchar, foo integer, bar boolean)[] := array[
('somename', 1, true),
('someothername', 2, false),
('yetothername', 3, true)];
BEGIN
...

Or maybe it is possible already? (I know there are temporary tables but it's 
not quite the same). The goal to have temporary local random access data 
structures (like lookup tables), similar to those in C.

-- 
regards
MM


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Re: Hot Standby query cancellation and Streaming Replication integration
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: function side effects