From rp2969@hotmail.com Fri Jun 4 19:39:05 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5B049D1B57C for ; Fri, 4 Jun 2004 16:39:05 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 92576-01 for ; Fri, 4 Jun 2004 19:38:56 +0000 (GMT) Received: from hotmail.com (sea1-dav18.sea1.hotmail.com [207.68.162.122]) by svr1.postgresql.org (Postfix) with ESMTP id 3A10CD1B562 for ; Fri, 4 Jun 2004 16:38:54 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 4 Jun 2004 12:38:55 -0700 Received: from 209.82.15.216 by sea1-dav18.sea1.hotmail.com with DAV; Fri, 04 Jun 2004 19:38:54 +0000 X-Originating-IP: [209.82.15.216] X-Originating-Email: [rp2969@hotmail.com] X-Sender: rp2969@hotmail.com From: "Rein Petersen" To: Subject: ANSI SQL-99 SYNTAX and "WITH" Date: Fri, 4 Jun 2004 15:37:41 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003B_01C44A49.DF6DF590" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Message-ID: X-OriginalArrivalTime: 04 Jun 2004 19:38:55.0299 (UTC) FILETIME=[927F5130:01C44A6B] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.7 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS, HTML_30_40, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200406/38 X-Sequence-Number: 17983 This is a multi-part message in MIME format. ------=_NextPart_000_003B_01C44A49.DF6DF590 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 "W= ITH" clause - which if I understand correctly, allows recursive joins in si= mple syntax without the use of cursors and/or otherwise klugey SQL. As you may have guessed, I hope PostgreSQL currently supports the "WITH" cl= ause syntax or, will at least support it imminently. Any knowledge on the matter is greatly appreciated :) Rein ------=_NextPart_000_003B_01C44A49.DF6DF590 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Good morning,afternoon, and=20 evening Everyone,
 
My research into PostgreSQL documentation = has yet=20 to yeild any information about PostgreSQL's support of ANSI SQL-99 syntax, = and=20 in particular, the "WITH" clause - which if I understand correctly, al= lows=20 recursive joins in simple syntax without the use of cursors and/or otherwis= e=20 klugey SQL.
 
As you may have guessed, I hope PostgreSQL= =20 currently supports the "WITH" clause syntax or, will at least support=20 it imminently.
 
Any knowledge on the matter is greatly app= reciated=20 :)
 
Rein
------=_NextPart_000_003B_01C44A49.DF6DF590-- From ymalik@cs.stevens-tech.edu Fri Jun 4 19:51:12 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 30C86D1B488 for ; Fri, 4 Jun 2004 16:51:12 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 92896-04 for ; Fri, 4 Jun 2004 19:51:10 +0000 (GMT) Received: from guinness.cs.stevens-tech.edu (guinness.cs.stevens-tech.edu [155.246.89.8]) by svr1.postgresql.org (Postfix) with ESMTP id E7A0FD1B3D9 for ; Fri, 4 Jun 2004 16:51:07 -0300 (ADT) Received: from pink-elephant.cs.stevens-tech.edu (pink-elephant.cs.stevens-tech.edu [155.246.81.117]) by guinness.cs.stevens-tech.edu (Postfix) with ESMTP id A8B46141669; Fri, 4 Jun 2004 15:51:44 -0400 (EDT) Received: by pink-elephant.cs.stevens-tech.edu (Postfix, from userid 4405) id 08C718AEAD; Fri, 4 Jun 2004 15:51:06 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by pink-elephant.cs.stevens-tech.edu (Postfix) with ESMTP id CE44E8AEA7; Fri, 4 Jun 2004 15:51:06 -0400 (EDT) Date: Fri, 4 Jun 2004 15:51:06 -0400 (EDT) From: Yasir Malik To: Rein Petersen Cc: pgsql-sql@postgresql.org Subject: Re: ANSI SQL-99 SYNTAX and "WITH" In-Reply-To: Message-ID: References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_RFCI X-Spam-Level: X-Archive-Number: 200406/39 X-Sequence-Number: 17984 > 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 bruno@wolff.to Fri Jun 4 19:56:51 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EAE6DD1B488 for ; Fri, 4 Jun 2004 16:56:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99594-03 for ; Fri, 4 Jun 2004 19:56:50 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 9F50AD1B256 for ; Fri, 4 Jun 2004 16:56:47 -0300 (ADT) Received: (qmail 24048 invoked by uid 500); 4 Jun 2004 20:02:28 -0000 Date: Fri, 4 Jun 2004 15:02:28 -0500 From: Bruno Wolff III To: Rein Petersen Cc: pgsql-sql@postgresql.org Subject: Re: ANSI SQL-99 SYNTAX and "WITH" Message-ID: <20040604200228.GA23948@wolff.to> Mail-Followup-To: Rein Petersen , pgsql-sql@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=MAILTO_TO_SPAM_ADDR X-Spam-Level: * X-Archive-Number: 200406/40 X-Sequence-Number: 17985 On Fri, Jun 04, 2004 at 15:37:41 -0400, Rein Petersen 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. From tgl@sss.pgh.pa.us Fri Jun 4 20:43:42 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 36CB7D1B896 for ; Fri, 4 Jun 2004 17:43:42 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20148-04 for ; Fri, 4 Jun 2004 20:43:38 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 71659D1B28B for ; Fri, 4 Jun 2004 17:43:35 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i54KhXng010376; Fri, 4 Jun 2004 16:43:33 -0400 (EDT) To: Bruno Wolff III Cc: Rein Petersen , pgsql-sql@postgresql.org Subject: Re: ANSI SQL-99 SYNTAX and "WITH" In-reply-to: <20040604200228.GA23948@wolff.to> References: <20040604200228.GA23948@wolff.to> Comments: In-reply-to Bruno Wolff III message dated "Fri, 04 Jun 2004 15:02:28 -0500" Date: Fri, 04 Jun 2004 16:43:33 -0400 Message-ID: <10375.1086381813@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=MAILTO_TO_SPAM_ADDR X-Spam-Level: * X-Archive-Number: 200406/41 X-Sequence-Number: 17986 Bruno Wolff III writes: > Rein Petersen 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 I haven't heard anything lately, so I don't know if some version > of it is going to be in the next release. Andrew Overholt was working on it awhile back. I've been meaning to pick up the pieces and see what I could do with it, but at this point it's a pretty safe bet that it won't make 7.5. Maybe next time. regards, tom lane