Postgresql multidimensional arrays cast fail

From: alexandros_e <alexandros(dot)ef(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgresql multidimensional arrays cast fail
Date: 2014-02-01 09:45:11
Message-ID: 1391247911255-5790077.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I do:

SELECT '{{1,2},{3,4}}'::INTEGER[][]

But I get:

{{1,2},{3,4}} INTEGER[]. Somehow the PostgreSQL server does not understand
that is a multidimensional array. So, later if I want to get {1,2} or {3,4},
the field[1] or field[2]. Evem when I try:

field [1:1] I get {{1,2}} and not plain one dimensional integer array {1,2}
which I want. How do I achieve that?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Postgresql-multidimensional-arrays-cast-fail-tp5790077.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2014-02-01 09:45:48 Re: manual and autovacuum
Previous Message prashant Pandey 2014-02-01 08:20:07 manual and autovacuum