Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BAC7A476E9D for ; Tue, 28 Jan 2003 06:35:47 -0500 (EST) Received: from homer.meirion-dwyfor.ac.uk (mailsun.meirion-dwyfor.ac.uk [194.82.228.2]) by postgresql.org (Postfix) with ESMTP id C8B1E476E95 for ; Tue, 28 Jan 2003 06:35:46 -0500 (EST) Received: from cuneddawledig.meirion-dwyfor.ac.uk (calimero.wwwcache.meirion-dwyfor.ac.uk [194.82.229.6]) by homer.meirion-dwyfor.ac.uk (8.11.6/8.8.7) with ESMTP id h0SCb2r00951; Tue, 28 Jan 2003 12:37:02 GMT Received: from spac1.meirion-dwyfor.ac.uk ([10.4.0.2]) by cuneddawledig.meirion-dwyfor.ac.uk (8.12.3/8.12.3/SuSE Linux 0.6) with ESMTP id h0SAfamT018771; Tue, 28 Jan 2003 10:41:36 GMT Received: from gandalf ([10.4.0.12]) by spac1.meirion-dwyfor.ac.uk (8.12.2/8.12.2/SuSE Linux 0.6) with ESMTP id h0SBKup1029302; Tue, 28 Jan 2003 11:20:56 GMT Content-Type: text/plain; charset="iso-8859-1" From: Geraint Jones Organization: Coleg Meirion-Dwyfor To: "william windels" , Subject: Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1 Date: Tue, 28 Jan 2003 10:27:39 +0000 X-Mailer: KMail [version 1.4] References: <000901c2c6b5$2deef350$240aa8c0@L1PC01> In-Reply-To: <000901c2c6b5$2deef350$240aa8c0@L1PC01> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200301281027.39293.geraint.jones@meirion-dwyfor.ac.uk> X-Virus-Scanned: by amavis-milter (http://amavis.org/) X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/429 X-Sequence-Number: 11294 On Tuesday 28 January 2003 10:08 am, william windels wrote: A lot of SQL! Instead of spending a lot of time trying to figure out what's= =20 wrong with your code, here's a couple of links that should help you: The most obvious is the PostgreSQL documentation which can be found in the = doc=20 directory of your PostgreSQL installation (usually /usr/local/pgsql/doc if= =20 you're using Linux), or on the Internet at: http://www.postgresql.org/ Then there's a book online - Practical PostgreSQL: http://www.commandprompt.com/ppbook/book1.htm Geraint.