Re: ANSI SQL-99 SYNTAX and "WITH"

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Rein Petersen <rp2969(at)hotmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: ANSI SQL-99 SYNTAX and "WITH"
Date: 2004-06-04 20:02:28
Message-ID: 20040604200228.GA23948@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, Jun 04, 2004 at 15:37:41 -0400,
Rein Petersen <rp2969(at)hotmail(dot)com> wrote:
> My research into PostgreSQL documentation has yet to yeild any information about PostgreSQL's support of ANSI SQL-99 syntax, and in particular, the "WITH" clause - which if I understand correctly, allows recursive joins in simple syntax without the use of cursors and/or otherwise klugey SQL.
>
> As you may have guessed, I hope PostgreSQL currently supports the "WITH" clause syntax or, will at least support it imminently.

Postgres doesn't currently support that. Someone was working on it a while
back, but I haven't heard anything lately, so I don't know if some version
of it is going to be in the next release.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-06-04 20:43:33 Re: ANSI SQL-99 SYNTAX and "WITH"
Previous Message Yasir Malik 2004-06-04 19:51:06 Re: ANSI SQL-99 SYNTAX and "WITH"