public inbox for [email protected]  

help / color / mirror / Atom feed

Valued Predicates
3+ messages / 2 participants
[nested] [flat]

* Valued Predicates
@ 2006-11-16 05:55  Richard Broersma Jr <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Richard Broersma Jr @ 2006-11-16 05:55 UTC (permalink / raw)
  To: 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.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Valued Predicates
@ 2006-11-16 06:14  Tom Lane <[email protected]>
  parent: Richard Broersma Jr <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2006-11-16 06:14 UTC (permalink / raw)
  To: Richard Broersma Jr <[email protected]>; +Cc: pgsql-docs

Richard Broersma Jr <[email protected]> writes:
> 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.

Which part of this do you claim is not documented?  It looks to me like
it's all covered in one of

http://developer.postgresql.org/pgdocs/postgres/functions-comparison.html
http://developer.postgresql.org/pgdocs/postgres/functions-comparisons.html#ROW-WISE-COMPARISON

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Valued Predicates
@ 2006-11-16 06:36  Richard Broersma Jr <[email protected]>
  parent: Tom Lane <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Richard Broersma Jr @ 2006-11-16 06:36 UTC (permalink / raw)
  To: Tom Lane <[email protected]>; +Cc: pgsql-docs

> Which part of this do you claim is not documented?  It looks to me like
> it's all covered in one of
> 
> http://developer.postgresql.org/pgdocs/postgres/functions-comparison.html
> http://developer.postgresql.org/pgdocs/postgres/functions-comparisons.html#ROW-WISE-COMPARISON

I see it now.  Sorry for the false static.

Regards,

Richard Broersma Jr.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2006-11-16 06:36 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-16 05:55 Valued Predicates Richard Broersma Jr <[email protected]>
2006-11-16 06:14 ` Tom Lane <[email protected]>
2006-11-16 06:36   ` Richard Broersma Jr <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox