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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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" <rp2969@hotmail.com>
To: <pgsql-sql@postgresql.org>
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: <Sea1-DAV18EovZCNb7P0002db44@hotmail.com>
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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Good morning,afternoon, and=20
evening&nbsp;Everyone,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>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,&nbsp;al=
lows=20
recursive joins in simple syntax without the use of cursors and/or otherwis=
e=20
klugey SQL.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>As you may have guessed, I hope PostgreSQL=
=20
currently supports the "WITH" clause syntax or, will at least support=20
it&nbsp;imminently.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Any knowledge on the matter is greatly app=
reciated=20
:)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Rein</FONT></DIV></BODY></HTML>

------=_NextPart_000_003B_01C44A49.DF6DF590--