> > 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