X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FManual%2FCookbook.pod;h=00c28e9dba131a191fba91b6ce6eb67c82e62ce9;hb=0a62f675479175606ba25cc28e0c28fb17425b0d;hp=678e173cacf7d516c4f5498c3a3a98bbe942855c;hpb=eef68d59ea5126da31955189bc42e8459c8ed5f1;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/lib/DBIx/Class/Manual/Cookbook.pod b/lib/DBIx/Class/Manual/Cookbook.pod index 678e173..00c28e9 100644 --- a/lib/DBIx/Class/Manual/Cookbook.pod +++ b/lib/DBIx/Class/Manual/Cookbook.pod @@ -316,6 +316,11 @@ The following will B work: artist_id => $inside_rs->get_column('id')->as_query, }); +=head3 Support + +Subqueries are supported in the where clause (first hashref), and in the +from, select, and +select attributes. + =head3 Correlated subqueries my $cdrs = $schema->resultset('CD'); @@ -338,12 +343,6 @@ That creates the following SQL: WHERE artistid = me.artistid ) -=head2 Where subqueries will work - -Currently, subqueries will B work in the where-clause of a search. In -other words, in the first hashref of a search() method. Work is being done -to make them work as part of the second hashref (from, select, +select, etc). - =head2 Predefined searches You can write your own L class by inheriting from it