From: Rob Kinyon Date: Sun, 29 Mar 2009 02:32:15 +0000 (-0400) Subject: Fleshed out final clauses for SELECT statement. No examples provided. X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=dbsrgits%2FSQL-Abstract-2.0-ish.git;a=commitdiff_plain;h=e4a310cba712660ae9bdf132f8ac5a0771551c94 Fleshed out final clauses for SELECT statement. No examples provided. --- diff --git a/lib/SQL/Abstract/Manual/Specification.pod b/lib/SQL/Abstract/Manual/Specification.pod index 32281db..1c933fd 100644 --- a/lib/SQL/Abstract/Manual/Specification.pod +++ b/lib/SQL/Abstract/Manual/Specification.pod @@ -508,18 +508,27 @@ The number corresponds to a column in the select clause. This corresponds to the clause that is used in some RDBMS engines to limit the number of rows returned by a query. In MySQL, this would be the LIMIT clause. -A rows clause is composed as follows: +The hash for a rows clause is composed as follows: - Number [, Number ] + { + type => 'Rows', + start => Number, + count => Number, + } + +The start attribute, if ommitted, will default to 0. The count attribute is +optional. =head3 for This corresponds to the clause that is used in some RDBMS engines to indicate what locks are to be taken by this SELECT statement. -A for clause is composed as follows: +The hash for a for clause is composed as follows: - UPDATE | DELETE + { + value => '< UPDATE | DELETE >', + } =head3 connectby