From: GB Clark <gclarkii@vsservices.com>
To: KH Lim <limspirit@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problem with the postgresql operator.
Date: Tue, 15 Jan 2002 09:56:29 -0600
Message-ID: <20020115095629.56e49d68.gclarkii@vsservices.com> (raw)
In-Reply-To: <OE675sUJliuVPPfnkR30000cd43@hotmail.com>
References: <OE675sUJliuVPPfnkR30000cd43@hotmail.com>
On Tue, 15 Jan 2002 14:39:54 +0800
"KH Lim" <limspirit@hotmail.com> wrote:
> Dear All,
>
> What is the correct operator for not equal to in select statement? I'm a bit confuse.
>
> Situation
>
> Let say I want to select stock_key from stock_lot with the condition stock_lot's lot_no is not equal to stocks' lot_no. What select statement should I use?
>
> Thank you in advance
>
> Lim
>
Just use the standard SQL... <>
Works just fine and it is in the books.
GB
--
GB Clark II | Roaming FreeBSD Admin
gclarkii@VSServices.COM | General Geek
CTHULU for President - Why choose the lesser of two evils?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gclarkii@vsservices.com, limspirit@hotmail.com
Subject: Re: Problem with the postgresql operator.
In-Reply-To: <20020115095629.56e49d68.gclarkii@vsservices.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox