From: | Yasir Malik <ymalik(at)cs(dot)stevens-tech(dot)edu> |
---|---|
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 19:51:06 |
Message-ID: | Pine.NEB.4.58.0406041548390.21293@pink-elephant.cs.stevens-tech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> 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 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.
No, PostgreSQL does not support the WITH clause. I wanted to use the WITH
clause in an assignment, but I ended up using a view. Maybe that will
work for you.
Yasir
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2004-06-04 20:02:28 | Re: ANSI SQL-99 SYNTAX and "WITH" |
Previous Message | Rein Petersen | 2004-06-04 19:37:41 | ANSI SQL-99 SYNTAX and "WITH" |