> > Tatsuo Ishii <[EMAIL PROTECTED]> 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your Subscription: http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-hackers
