Thread: All and ANY

http://www.postgresql.org/docs/9.1/static/functions-subquery.html

__________________________________________________________________________________
Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike.Blackwell@rrd.com
http://www.rrdonnelley.com

On 10/26/11 6:38 AM, salah jubeh wrote:
>
> Can someone please direct me where I can find documentation about ALL
> and ANY  functions.  I searched postgresql documentation but I did not
> find the appropriate pages
>


http://www.postgresql.org/docs/current/static/functions-subquery.html#FUNCTIONS-SUBQUERY-ANY-SOME
http://www.postgresql.org/docs/current/static/functions-comparisons.html#AEN17416

(note one operates on the results of a subquery, while the other nearly
identical page is operating on an array)

fyi, I found these quite directly by going to the Index
http://www.postgresql.org/docs/current/static/bookindex.html



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

On 27/10/11 02:38, salah jubeh wrote:

Can someone please direct me where I can find documentation about ALL and ANY  functions.  I searched postgresql documentation but I did not find the appropriate pages

 

Thanks in advance

Read the reference URLs provided by the other replies, as I quote only part of the pg 9.1.1 manual below to give a tast...

9.20.5. ALL

expression operator ALL (subquery)

The right-hand side is a parenthesized subquery, which must return exactly one column. The left-hand expression is evaluated and compared to each row of the subquery result using the given operator, which must yield a Boolean result. The result of ALL is "true" if all rows yield true (including the case where the subquery returns no rows). The result is "false" if any false result is found. The result is NULL if the comparison does not return false for any row, and it returns NULL for at least one row.

Cheers,
Gavin