> > 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.
> >
> >
> Tatsuo Ishii wrote:
> >> On Tue, Feb 19, 2008 at 3:36 AM, Tatsuo Ishii <[EMAIL PROTECTED]> wrote:
> >>
> > I hope so. But the first thing I would like to do is, to implement the
> > right thing (i.e. following the standard).
> >
> > I don't see any reason that the proposal gets less performa
Tatsuo Ishii wrote:
On Tue, Feb 19, 2008 at 3:36 AM, Tatsuo Ishii <[EMAIL PROTECTED]> wrote:
I hope so. But the first thing I would like to do is, to implement the
right thing (i.e. following the standard).
I don't see any reason that the proposal gets less performance than
existing functi
[This message is mostly for the benefit of the list -- he and I already talked
a bit about this here at FOSDEM. Ishii-san, if you have a chance we should sit
down and talk about this in more detail before we leave!]
Tatsuo Ishii wrote:
>> On Tue, Feb 19, 2008 at 3:36 AM, Tatsuo Ishii <[EMAIL PRO
> On Tue, Feb 19, 2008 at 3:36 AM, Tatsuo Ishii <[EMAIL PROTECTED]> wrote:
> > We propose to implement the recursive query (WITH RECURSIVE clause)
> > defined in SQL:1999 and later. With the recursive query, one can
> > easily inquire the data expressed as tree and graph structures. The
> > ac
On Tue, Feb 19, 2008 at 3:36 AM, Tatsuo Ishii <[EMAIL PROTECTED]> wrote:
> We propose to implement the recursive query (WITH RECURSIVE clause)
> defined in SQL:1999 and later. With the recursive query, one can
> easily inquire the data expressed as tree and graph structures. The
> actual synta
> 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
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 o
Hi,
As I promised before we would like to propose implementing the
recursive query as defined in the standard for PostgreSQL 8.4.
The work is supported by Sumitomo Electric Information Systems Co.,
Ltd. (http://www.sei-info.co.jp/) and SRA OSS, Inc. Japan
(http://www.sraoss.co.jp).
1. Overview
