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

From Tatsuo Ishii
Subject Re: RFP: Recursive query in 8.4
Date
Msg-id 20080223.002319.51855611.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: RFP: Recursive query in 8.4  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
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

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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Linking backend in one piece
Next
From: Andrew Dunstan
Date:
Subject: Re: Including PL/PgSQL by default