Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types

Поиск
Список
Период
Сортировка
Искать
От
Artur Zakirov
Тема
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types
Дата
Msg-id
567818E4.3030205@postgrespro.ru
Ответ на
Список
Дерево обсуждения
plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Artur Zakirov <a.zakirov@postgrespro.ru>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Alvaro Herrera <alvherre@2ndquadrant.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Alvaro Herrera <alvherre@2ndquadrant.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Robert Haas <robertmhaas@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Peter Eisentraut <peter_e@gmx.net>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Joe Conway <mail@joeconway.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Tom Lane <tgl@sss.pgh.pa.us>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Tom Lane <tgl@sss.pgh.pa.us>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Robert Haas <robertmhaas@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Tom Lane <tgl@sss.pgh.pa.us>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Tom Lane <tgl@sss.pgh.pa.us>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Bruce Momjian <bruce@momjian.us>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Joe Conway <mail@joeconway.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Joe Conway <mail@joeconway.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Tom Lane <tgl@sss.pgh.pa.us>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Artur Zakirov <a.zakirov@postgrespro.ru>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Tom Lane <tgl@sss.pgh.pa.us>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types "David G. Johnston" <david.g.johnston@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Robert Haas <robertmhaas@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Robert Haas <robertmhaas@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Artur Zakirov <a.zakirov@postgrespro.ru>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Artur Zakirov <a.zakirov@postgrespro.ru>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Pavel Stehule <pavel.stehule@gmail.com>
Re: plpgsql - DECLARE - cannot to use %TYPE or %ROWTYPE for composite types Michael Paquier <michael.paquier@gmail.com>
Hi.
I have tried to do some review of this patch. Below are my comments.

Introduction:

This patch fixes and adds the following functionality:
- %TYPE - now can be used for composite types.
- %ARRAYTYPE - new functionality, provides the array type from a 
variable or table column.
- %ELEMENTTYPE - new funcitonality, provides the element type of a given 
array.

New regression tests are included in the patch. Changes to the 
documentation are not provided.

Initial Run:

The patch applies correctly to HEAD. Regression tests pass successfully, 
without errors. It seems that the patch work as you expected.

Performance:

It seems patch have not possible performance issues for the existing 
functionality.

Coding:

The style looks fine. I attached the patch that does some corrections in 
code and documentation. I have corrected indentation in pl_comp.c and 
"read_datatype" function in pl_gram.y. I think changes in 
"read_datatype" function would be better to avoid a code duplication. 
But I could be wrong of course.

Conclusion:

The patch could be applied on master with documentation corrections. But 
I'm not sure that your task could be resloved only by adding %ARRAYTYPE 
and %ELEMENTTYPE. Maybe you will give some examples?

-- 
Artur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
В списке pgsql-hackers по дате отправления
От: Fabien COELHO
Дата:
От: Viktor Leis
Дата:
FAQ