Re: unnest on multi-dimensional arrays
| От | Pavel Stehule |
|---|---|
| Тема | Re: unnest on multi-dimensional arrays |
| Дата | |
| Msg-id | CAFj8pRD1p_1nbGP1P59NexdW7Leymf4Zc9WFuCpkJDaJxZPT0w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: unnest on multi-dimensional arrays (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-general |
2013/12/2 Tom Lane <tgl@sss.pgh.pa.us>
Zev Benjamin <zev-pgsql@strangersgate.com> writes:Well, you'd also need some execution-time infrastructure to evaluate an
> This actually looks to mostly be a parser limitation:
expression, if we allowed one there, but I agree it wouldn't be a
tremendously complicated patch. We'd just not foreseen a good reason
to support an expression ...
I afraid so it is not too simple.
There is problem with different target type when you do reduction from array to scalar and from array to array sometimes (for different slice) - so principally slice parameter should be immutable due immutable target type. Although current solution is not enough protection against same error, so then we allow a integer expression there.
Regards
Pavel
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: