DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=Csy9GBOVKVbDC7Fa6GyUQX9jAvtYMAhof2oQ4TrBkDMEDTLd+NU31BQfTu82DHQ9Qx+cscXoQ6NWuMrC8pMjY0wsuTcRuysw9K03hsiwPnPP786mauqsH0qapQRs309K/F6UQ1vO/DJK5In3a1KSheY5LJ5KwQW8abDxwVabaBA=
	;
Date: Wed, 15 Nov 2006 21:55:21 -0800 (PST)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Valued Predicates
To: pgsql-docs@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <740909.36746.qm@web31802.mail.mud.yahoo.com>

In my reading of SQL for smarties I've stumbled across syntax that is supported by Postgresql. 
However, I can't find mention of it in the Postgresql Docs.  Would an appropriate location for
this syntax be the "where condition" of the insert/update/select/delete statements?

i.e.

mydb=# select * from test2 where ( (a,b) >= (1,'A') ) is unknown;
 a | b
---+---
 3 |
(1 row)
mydb=# select * from test2 where ( (a,b) >= (1,'A') ) is true;
 a |   b
---+--------
 1 | Albert
 2 | Bert
(2 rows)
mydb=# select * from test2 where ( (a,b) >= (1,'A') ) is false;
 a | b
---+---
(0 rows)
mydb=# select * from test2 where ( (a,b) >= (1,'A') ) is not false;
 a |   b
---+--------
 1 | Albert
 2 | Bert
 3 |
(3 rows)
mydb=# select * from test2 where ( (a,b) >= (1,'A') ) is not true;
 a | b
---+---
 3 |
(1 row)
mydb=# select * from test2 where ( (a,b) >= (1,'A') ) is not true;
 a | b
---+---
 3 |
(1 row)

Regards,

Richard Broersma Jr.