Re: Problem with the postgresql operator.

From: GB Clark <gclarkii(at)vsservices(dot)com>
To: "KH Lim" <limspirit(at)hotmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Problem with the postgresql operator.
Date: 2002-01-15 15:56:29
Message-ID: 20020115095629.56e49d68.gclarkii@vsservices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 15 Jan 2002 14:39:54 +0800
"KH Lim" <limspirit(at)hotmail(dot)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(at)VSServices(dot)COM | General Geek
CTHULU for President - Why choose the lesser of two evils?

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-01-15 16:33:55 Re: Hierarchical queries
Previous Message Jeff Eckermann 2002-01-15 15:03:41 Re: Resources - Regular Expressions