Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 63BA2633957
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 11 Jan 2010 20:10:46 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 87558-08 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 12 Jan 2010 00:10:35 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by mail.postgresql.org (Postfix) with ESMTP id C74006338FB
	for <pgsql-sql@postgresql.org>; Mon, 11 Jan 2010 20:10:35 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o0C0AXMG021776;
	Mon, 11 Jan 2010 19:10:33 -0500 (EST)
To: Andy Shellam <andy-lists@networkmail.eu>
cc: pgsql-sql@postgresql.org
Subject: Re: CHECK constraint removing brackets 
In-reply-to: <C433EA79-69F9-4372-B04C-D59BC94434C6@networkmail.eu> 
References: <D884BF27-7555-40BA-8A5E-CAEE1272CE26@networkmail.eu>
	<18738.1263240918@sss.pgh.pa.us>
	<C433EA79-69F9-4372-B04C-D59BC94434C6@networkmail.eu>
Comments: In-reply-to Andy Shellam <andy-lists@networkmail.eu>
	message dated "Mon, 11 Jan 2010 23:27:35 +0000"
Date: Mon, 11 Jan 2010 19:10:33 -0500
Message-ID: <21775.1263255033@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.589 tagged_above=-10 required=5
	tests=BAYES_00=-2.599, FH_DATE_PAST_20XX=3.188
X-Spam-Level: 
X-Archive-Number: 201001/22
X-Sequence-Number: 33558

Andy Shellam <andy-lists@networkmail.eu> writes:
> I know about the <> and !=, for some reason != has always made better sense to me to read, so I tend to write it that way.

Yeah, a lot of people prefer != ... that's why we provide it as an
alias for <>.  There's no functional difference.

			regards, tom lane