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
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 |