I am under the impression that this should be an error. Am I wrong?
EXAMPLE 1:
maint=# select ('{{1,2,3},{4,5,6}}'::int[])[1][1:3];
int4
-----------
{{1,2,3}}
(1 row)Shouldn't this have been just {1,2,3} ?
EXAMPLE 2:
maint=# select ('{{1,2,3},{4,5,6}}'::int[])[2][1:3];
int4
-----------
{{1,2,3},{4,5,6}}
(1 row)Shouldn't this have been just {4,5,6} (or maybe {{4,5,6}} accepting the result of example 1) ?
I am trying to do sth like:
maint=# select 1 = any ('{{1,2,3},{4,5,6}}'::int[])[2][1:3];
But that is not working for obvious reasons. This makes arrays pretty broken for me.
Am I missing anything obvious?
Regards,
David Helgason Over the Edge Entertainments
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
