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

Will check. Thanks for pointing it out.
--
Tatsuo Ishii
SRA OSS, Inc. Japan