2D arrays in 7.3... actually, parser bug?

From: Eric B(dot)Ridge <ebr(at)tcdi(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 2D arrays in 7.3... actually, parser bug?
Date: 2003-01-31 04:54:30
Message-ID: 157F2A4B-34D8-11D7-AB6A-0003930C70D8@tcdi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

zzzz=# select version();
version
------------------------------------------------------------------------
------------------------
PostgreSQL 7.3 on powerpc-apple-darwin6.3, compiled by GCC gcc (GCC)
3.1 20020420 (prerelease)
(1 row)

Being too lazy to RTFM, I decided to discover on my own if postgres
supported 2D array types:

zzzz=# create table foo (bar int8[][]);
CREATE TABLE

(Oh cool! it does!)

zzzz=# \d foo
Table "public.foo"
Column | Type | Modifiers
--------+----------+-----------
bar | bigint[] |

(hmm, that doesn't look right. <pause> *snicker* Hmm, I wonder...)

zzzz=# create table foo2 (bar int8[][][][][][][][]);
CREATE TABLE
zzzz=# \d foo2
Table "public.foo2"
Column | Type | Modifiers
--------+----------+-----------
bar | bigint[] |

So now my question is, since postgres doesn't support 2D (or N-D)
arrays, shouldn't the above produce some kind of syntax error?

eric

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message codeWarrior 2003-01-31 05:15:41 Re: Basic SQL join question
Previous Message Curt Sampson 2003-01-31 03:54:26 Re: One large v. many small