On Thu, Jun 30, 2011 at 5:44 AM, Maxim Boguk <maxim.bo...@gmail.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 6087
> Logged by: Maxim Boguk
> Email address: maxim.bo...@gmail.com
> PostgreSQL version: 9.0
> Operating system: Linux
> Description: Unnest with multidimensional arrays
> Details:
>
> I not sure is it actual bug or intended behaviour.
> In documentation unnest described as:
> "expand an array to a set of rows".
>
> However in case of multidimensional arrays documentation is misleading or
> actual behaviour is wrong.
>
> Test case:
>
> postgres=# select unnest(array[[1,2], [3,4], [5,6]]);
> unnest
> --------
> 1
> 2
> 3
> 4
> 5
> 6
> (6 rows)
>
> I think correct result must be:
> unnest
> ------------
> {1,2}
> {3,4}
> {5,6}
not a bug. however if you'd like to submit a patch to clarify that,
feel free...
do you need to be able to cut up arrays like that?
merlin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
