Re: select :all

On Mar 28, 2010, at 9:32 PM, Harald Hanche-Olsen wrote:
> + 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.

	That makes sense, thanks.

Regards,

Patrick

_______________________________________________
CLSQL mailing list
[email protected]
http://lists.b9.com/cgi-bin/mailman/listinfo/clsql