Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 85198475AE5 for ; Tue, 3 Dec 2002 03:06:42 -0500 (EST) Received: from acheron.rime.com.au (unknown [203.208.66.49]) by postgresql.org (Postfix) with ESMTP id 9E811475A09 for ; Tue, 3 Dec 2002 03:06:41 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386)) with ESMTP id 60C525457F; Tue, 3 Dec 2002 19:06:41 +1100 (EST) Received: by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386), from userid 527) id 512D554580; Tue, 3 Dec 2002 19:06:40 +1100 (EST) Received: from hephaestus.rhyme.com.au (unknown [203.8.195.124]) by acheron.rime.com.au (Postfix on SuSE Linux 8.0 (i386)) with ESMTP id DDFEB5457F; Tue, 3 Dec 2002 19:06:39 +1100 (EST) Message-Id: <5.1.0.14.0.20021203190406.041f3a18@mail.rhyme.com.au> X-Sender: pjw@mail.rhyme.com.au X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Tue, 03 Dec 2002 19:05:07 +1100 To: "Rachel.Vaudron" , From: Philip Warner Subject: Re: EXIST / NOT EXIST In-Reply-To: References: <20934.1038899176@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Spam-Status: No, hits=-2.0 required=8.5 tests=IN_REP_TO,DOUBLE_CAPSWORD,WEIRD_PORT version=2.31 X-Spam-Level: X-Virus-Scanned: by AMaViS 0.3.12pre8 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/20 X-Sequence-Number: 10608 At 09:01 AM 3/12/2002 +0100, Rachel.Vaudron wrote: >I would like to know if the keyword EXIST can be used with PostgreSQL ? EXISTS is supported (ie. trailing 'S'). ---------------------------------------------------------------- Philip Warner | __---_____ Albatross Consulting Pty. Ltd. |----/ - \ (A.B.N. 75 008 659 498) | /(@) ______---_ Tel: (+61) 0500 83 82 81 | _________ \ Fax: (+61) 03 5330 3172 | ___________ | Http://www.rhyme.com.au | / \| | --________-- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/