X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FAbstract%2FManual%2FExamples.pod;h=651134cb70dc8ed5ccbac597440c905d6d5be601;hb=3004ebb7358fd8e8c133321b666ea7a609a16823;hp=a98e8908bf433c4ba9a4c280abbdfab329603928;hpb=662b716d50f233a948efa00a844a90298b356761;p=dbsrgits%2FSQL-Abstract-2.0-ish.git

diff --git a/lib/SQL/Abstract/Manual/Examples.pod b/lib/SQL/Abstract/Manual/Examples.pod
index a98e890..651134c 100644
--- a/lib/SQL/Abstract/Manual/Examples.pod
+++ b/lib/SQL/Abstract/Manual/Examples.pod
@@ -39,7 +39,10 @@ one. The SQL used is from the MySQL dialect.
                   type     => 'Function',
                   function => 'NOW',
               },
-              as => 'time',
+              as => {
+                  type => 'Identifier',
+                  element1 => 'time',
+              },
           },
       ],
       tables => {
@@ -48,7 +51,10 @@ one. The SQL used is from the MySQL dialect.
               type => 'Identifier',
               element1 => 'dual',
           },
-          as => 'duality',
+          as => {
+              type => 'Identifier',
+              element1 => 'duality',
+          },
       },
   }
 
@@ -447,6 +453,38 @@ one. The SQL used is from the MySQL dialect.
       },
   }
 
+=item * SELECT * FROM ( SELECT 1 ) AS foo
+
+  {
+      type => 'select',
+      ast_version => 0.0001,
+      select => [
+          {
+              type => 'Identifier',
+              element1 => '*',
+          },
+      ],
+      tables => {
+          type => 'Identifier',
+          element1 => 'foo',
+          value => {
+              type => 'select',
+              ast_version => 0.0001,
+              select => [
+                  {
+                      type    => 'Value',
+                      subtype => 'Number',
+                      value   => 1,
+                  },
+              ],
+          },
+          as => {
+              type => 'Identifier',
+              element1 => 'foo',
+          },
+      },
+  }
+
 =back
 
 =head1 AUTHORS