Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0FAY0V28020 for ; Tue, 15 Jan 2002 05:34:01 -0500 (EST) (envelope-from olly@lfix.co.uk) Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk) by anchor-post-31.mail.demon.net with esmtp (Exim 2.12 #1) id 16QQuo-000Iag-0V; Tue, 15 Jan 2002 10:34:02 +0000 Received: from localhost.localdomain (olly@localhost [127.0.0.1]) by linda.lfix.co.uk (8.12.1/8.12.1/Debian -5) with ESMTP id g0FAZNcb005531; Tue, 15 Jan 2002 10:35:23 GMT Subject: Re: Problem with the postgresql operator. From: Oliver Elphick To: KH Lim Cc: pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-Zcd1yHkJpSxsaGDn1igO" X-Mailer: Evolution/1.0 (Preview Release) Date: 15 Jan 2002 10:35:22 +0000 Message-Id: <1011090923.9010.32.camel@linda> Mime-Version: 1.0 X-Archive-Number: 200201/162 X-Sequence-Number: 6248 --=-Zcd1yHkJpSxsaGDn1igO Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Tue, 2002-01-15 at 06:39, KH Lim wrote: > Dear All, >=20 > What is the correct operator for not equal to in select statement? I'= m a bit confuse. >=20 > Situation >=20 > Let say I want to select stock_key from stock_lot with the condition stoc= k_lot's lot_no is not equal to stocks' lot_no. What select statement should= I use? The operator is !=3D=20 --=20 Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "For I know that my redeemer liveth, and that he shall=20 stand at the latter day upon the earth"=20=20=20=20=20=20=20=20=20=20= =20=20=20 Job 19:25=20 --=-Zcd1yHkJpSxsaGDn1igO Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQA8RAXqYU1MND4dDBwRAoP2AJ9JxWgw2ZPJiCAzrSXuRE0QwDStCwCeIdOJ 38joHKrGEzbQBQ7Lg4BJDxc= =kd5I -----END PGP SIGNATURE----- --=-Zcd1yHkJpSxsaGDn1igO--