Re: RFP: Recursive query in 8.4

Tatsuo Ishii <ishii@postgresql.org> wrote:

> 5. Limitation with PostgreSQL
> 
> 1) we do not implement SEARCH clause and CYCLE clause. This is because
>    we need array of rows to implement them. Note that there's no
>    support for array of rows in PostgreSQL.

What is difference between "array of rows" and
Arrays of composite types, that is new feature in 8.3 ?

=# CREATE TABLE foo (i integer);
CREATE TABLE
=# CREATE TABLE bar (foos foo[]);  -- *here*
CREATE TABLE

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center