Re: unnest on multi-dimensional arrays - Mailing list pgsql-general

From Pavel Stehule
Subject Re: unnest on multi-dimensional arrays
Date
Msg-id CAFj8pRD1p_1nbGP1P59NexdW7Leymf4Zc9WFuCpkJDaJxZPT0w@mail.gmail.com
Whole thread Raw
In response to Re: unnest on multi-dimensional arrays  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Shuwn Yuan Tee
Date:
Subject: Postgres 9.3 read block error went into recovery mode
Next
From: Steven Schlansker
Date:
Subject: Timing for release with fix for "Nov2013ReplicationIssue"