Re: select :all

+ Patrick May <[email protected]>:

> 	What is the meaning of the :all keyword in select?  Is it 
> necessary to ensure that all rows are returned from the database?

CLSQL manual: The keyword arguments all, distinct, from, group-by, 
having, limit, offset, order-by, set-operation and where are used to 
specify, using the symbolic SQL syntax, the corresponding components 
of the SQL query generated by the call to select.

SQL syntax 
(http://www.postgresql.org/docs/8.4/static/sql-select.html):
In connection with this part of the SELECT syntax:
{ UNION | INTERSECT | EXCEPT } [ ALL ] select ]
In all three cases, duplicate rows are eliminated unless ALL is 
specified.

- Harald