Re: Arrays of records?

Hello

you can test it. PostgreSQL 8.3 supports it.

postgres=# CREATE TYPE at AS (a integer, b integer);
CREATE TYPE
postgres=# CREATE TABLE foo(a at[]);
CREATE TABLE
postgres=# INSERT INTO foo VALUES(ARRAY[(10,20)::at]);
INSERT 0 1
postgres=# INSERT INTO foo VALUES(ARRAY[(10,20)::at, (20,30)::at]);
INSERT 0 1
postgres=# SELECT * FROM foo;
a
-----------------------
{"(10,20)"}
{"(10,20)","(20,30)"}
(2 rows)

postgres=# SELECT a[1] FROM foo;
a
---------
(10,20)
(10,20)
(2 rows)

postgres=# SELECT a[1].a FROM foo;
a
----
10
10
(2 rows)

regards

Pavel Stehule

2007/7/7, Chris Travers <chris(at)travelamericas(dot)com>:
> Hi all;
>
> I was wondering how one would define an array of complex data types or
> records. Any ideas or is this simply not supported?
>
> Best Wishes,
> Chris Travers
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>