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 20080304.234502.24599197.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: RFP: Recursive query in 8.4  (Tatsuo Ishii <ishii@sraoss.co.jp>)
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.

Yes, I agree with that the 8.3's new feature might be used to
implement SEARCH clause and CYCLE clause. Problem is, it requres that
the named composite type (the standard's term is "row type") is
previously defined.  Maybe we need "anonymous" row type?
--
Tatsuo Ishii
SRA OSS, Inc. Japan


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_dump additional options for performance
Next
From: Alvaro Herrera
Date:
Subject: Re: 8.3.0 Core with concurrent vacuum fulls