Re: RFP: Recursive query in 8.4

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
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-02-22 15:23:19
Message-ID: 20080223.002319.51855611.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.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2008-02-22 15:27:59 Re: Including PL/PgSQL by default
Previous Message Tom Lane 2008-02-22 15:16:45 Re: Linking backend in one piece