Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with the postgresql operator. - Mailing list pgsql-sql

From Oliver Elphick
Subject Re: Problem with the postgresql operator.
Date
Msg-id 1011090923.9010.32.camel@linda
Whole thread Raw
In response to Problem with the postgresql operator.  ("KH Lim" <limspirit@hotmail.com>)
List pgsql-sql
Tree view 
On Tue, 2002-01-15 at 06:39, KH Lim 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? 

The operator is !=

--
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      stand at the latter day upon the earth"
                                 Job 19:25

pgsql-sql by date:

Previous
From: "KH Lim"
Date:
Subject: Problem with the postgresql operator.
Next
From: "Steve Boyle \(Roselink\)"
Date:
Subject: Re: On delete cascade!