To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
From: John Scalia <jayknowsunix@gmail.com>
Subject: string not equal query, postgresql 9.4.4
Message-ID: <55FA13F1.7060204@gmail.com>
Date: Wed, 16 Sep 2015 20:14:25 -0500
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101
 Thunderbird/38.2.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi all,

Having a bit of a head-scratching problem. I'm writing a query where I want=
 to output only distinct rows where one char(4) field does not equal a spec=
ific value. Something like:

select distinct testname where result <> 'PASS";      #i.e., only the FAIL =
or WARN tests

I've tried several different variants like "!~", "not like ('PASS')", "is d=
istinct from 'PASS'", and so forth, but obviously I'm missing something as =
every row is being output not
just the ones which do not equal PASS. What would be the correct syntax for=
 this in a 9.4.4 database?
--
Jay


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin