Re: RFP: Recursive query in 8.4

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: RFP: Recursive query in 8.4
Date: 2008-03-04 14:45:02
Message-ID: 20080304.234502.24599197.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > Tatsuo Ishii <ishii(at)postgresql(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2008-03-04 16:35:44 Re: 8.3.0 Core with concurrent vacuum fulls
Previous Message Bruce Momjian 2008-03-04 14:39:19 Re: pg_dump additional options for performance