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:
> This actually looks to mostly be a parser limitation:

Well, you'd also need some execution-time infrastructure to evaluate an
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 по дате отправления:

Предыдущее
От: Shuwn Yuan Tee
Дата:
Сообщение: Postgres 9.3 read block error went into recovery mode
Следующее
От: Steven Schlansker
Дата:
Сообщение: Timing for release with fix for "Nov2013ReplicationIssue"