Search Postgresql Archives

Re: unnest on multi-dimensional arrays

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 






2013/12/2 Tom Lane <tgl@xxxxxxxxxxxxx>
Zev Benjamin <zev-pgsql@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux