Missing array support

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Cc: Joe Conway <mail(at)joeconway(dot)com>
Subject: Missing array support
Date: 2003-06-27 19:51:01
Message-ID: Pine.LNX.4.44.0306271735570.5890-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Some nice advances to SQL standard array support were made, but there are
a few things that don't work yet in the sense of feature S091 "Basic array
support". Joe, do you want to take on some of these? They should be
pretty easy (for you).

* Declaration of multidimensional arrays (see clause 6.1):

create table test2 (a int, b text array[5] array[6]);
ERROR: syntax error at or near "array" at character 44

* Empty arrays (see clause 6.4):

insert into test values (1, array[]);
ERROR: syntax error at or near "]" at character 35

* Cardinality function (returns array dimensions, see clause 6.17).

* Using an array as a table source using UNNEST, something like:

select * from unnest(test.b);

(Check the exact spec to be sure; clause 7.6.)

* Some information schema work (doing that now...)

--
Peter Eisentraut peter_e(at)gmx(dot)net

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2003-06-27 19:52:27 Possible mistake in new array syntax
Previous Message Rod Taylor 2003-06-27 19:36:11 7.2 to 7.4 upgrade issues

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2003-06-27 19:53:00 Re: array support patch phase 1 patch
Previous Message Böjthe Zoltán 2003-06-27 18:50:14 timetravel.c