| 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: | Whole Thread | Raw Message | 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.
| 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 |