Re: [PATCHES] [GENERAL] Empty arrays with ARRAY[]
От | Tom Lane |
---|---|
Тема | Re: [PATCHES] [GENERAL] Empty arrays with ARRAY[] |
Дата | |
Msg-id | 24773.1206049654@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: [GENERAL] Empty arrays with ARRAY[] ("Brendan Jurd" <direvus@gmail.com>) |
Ответы |
Re: [PATCHES] [GENERAL] Empty arrays with ARRAY[]
|
Список | pgsql-hackers |
"Brendan Jurd" <direvus@gmail.com> writes: > As discussed on -hackers, this patch allows the construction of an > empty array if an explicit cast to an array type is given (as in, > ARRAY[]::int[]). Applied with minor fixes; mostly, ensuring that the cast action would propagate down to sub-arrays, as in regression=# select array[[1],[2.2]]::int[]; array ----------- {{1},{2}} (1 row) I was interested to realize that this fix validates the decision to pass down the type information on-the-fly during transformExpr recursion. It would have been a lot more painful to do it if we'd taken the A_Const approach. I didn't do anything about removing A_Const's typename field, but I'm thinking that would be a good cleanup patch. regards, tom lane
В списке pgsql-hackers по дате отправления: