Re: RFP: Recursive query in 8.4 - Mailing list pgsql-hackers

From ITAGAKI Takahiro
Subject Re: RFP: Recursive query in 8.4
Date
Msg-id 20080222143700.8B76.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to RFP: Recursive query in 8.4  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: RFP: Recursive query in 8.4
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: [PATCHES] 2WRS [WIP]
Next
From: "Dave Page"
Date:
Subject: Re: Including PL/PgSQL by default