Valued Predicates

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: Valued Predicates
Date: 2006-11-16 05:55:21
Message-ID: 740909.36746.qm@web31802.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2006-11-16 06:14:27 Re: Valued Predicates
Previous Message Oleg Bartunov 2006-11-15 19:52:35 Re: small improvement to G.2.4.1. Installing OpenJade