Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]
Дата
Msg-id CAFj8pRBFePm8bQd_CJbyhf4f36iqZqO0x-PrFJLaZ=FmU+SUbA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]  (Quan Zongliang <quanzongliang@yeah.net>)
Ответы Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения


pá 24. 11. 2023 v 2:12 odesílatel Quan Zongliang <quanzongliang@yeah.net> napsal:


On 2023/11/24 03:39, Pavel Stehule wrote:

>
> I modified the documentation a little bit - we don't need to extra
> propose SQL array syntax, I think.
> I rewrote regress tests - we don't need to test unsupported
> functionality (related to RECORD).
>
> - all tests passed
>
I wrote two examples of errors:
   user_id users.user_id%ROWTYPE[];
   user_id users.user_id%ROWTYPE ARRAY[4][3];

there were more issues in this part - the name "user_id" is a bad name for a composite variable.  I renamed it.
+ I wrote a test related to usage type without array support.

Now, I think so this simple patch is ready for committers

Regards

Pavel



Fixed.

> Regards
>
> Pavel
>
>
>      >
>      > Regards
>      >
>      > Pavel
>
Вложения

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

Предыдущее
От: Dilip Kumar
Дата:
Сообщение: Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock
Следующее
От: Alena Rybakina
Дата:
Сообщение: Re: POC, WIP: OR-clause support for indexes