Re: Proposal to introduce a shuffle function to intarray extension

Поиск
Список
Период
Сортировка
От Martin Kalcher
Тема Re: Proposal to introduce a shuffle function to intarray extension
Дата
Msg-id 5b7a1ee9-f942-2502-3a0c-e9fc12511139@aboutsource.net
обсуждение исходный текст
Ответ на Re: Proposal to introduce a shuffle function to intarray extension  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Proposal to introduce a shuffle function to intarray extension  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Am 18.07.22 um 00:46 schrieb Tom Lane:
> 
> This does not look particularly idiomatic, or even type-safe.  What you
> should have done was use deconstruct_array to get an array of Datums and
> isnull flags, then shuffled those, then used construct_array to build the
> output.
> 
> (Or, perhaps, use construct_md_array to replicate the input's
> precise dimensionality.  Not sure if anyone would care.)
> 
>             regards, tom lane

deconstruct_array() would destroy the arrays dimensions. I would expect 
that shuffle() only shuffles the first dimension and keeps the inner 
arrays intact.

Martin



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Proposal to introduce a shuffle function to intarray extension
Следующее
От: "Dian M Fay"
Дата:
Сообщение: Re: doc: Make selectivity example match wording