[SQL] ANSI SQL-99 SYNTAX and WITH

2004-06-04 Thread Rein Petersen
Good morning,afternoon, and eveningEveryone, 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

Re: [SQL] ANSI SQL-99 SYNTAX and WITH

2004-06-04 Thread Yasir Malik
Good morning,afternoon, and evening Everyone, 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

Re: [SQL] ANSI SQL-99 SYNTAX and WITH

2004-06-04 Thread Bruno Wolff III
On Fri, Jun 04, 2004 at 15:37:41 -0400, Rein Petersen [EMAIL PROTECTED] 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

Re: [SQL] ANSI SQL-99 SYNTAX and WITH

2004-06-04 Thread Tom Lane
Bruno Wolff III [EMAIL PROTECTED] writes: Rein Petersen [EMAIL PROTECTED] wrote: 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