Commits

Kirill Simonov committed fc66d1f

Use anonymous hyperlinks in the showcase; updated syntax in the projection example.

Comments (0)

Files changed (1)

     FROM "ad"."department" AS "department"
     ORDER BY 1 ASC
 
-This query (Q1_) returns all departments.
+`This query`__ returns all departments.
 
-.. _Q1: http://demo.htsql.org/department
+__ http://demo.htsql.org/department
 
 Selecting Columns
 -----------------
       ON ("department"."school" = "school"."code")
       ORDER BY "department"."code" ASC
 
-This query (Q2_) returns, for each department, the name of the
+`This query`__ returns, for each department, the name of the
 associated school and the name of the department.
 
-.. _Q2:
-     http://demo.htsql.org
-     /department{school.name, name}
+__ http://demo.htsql.org
+        /department{school.name, name}
 
 Filtering Rows
 --------------
          AND ("department"."school" = 'eng')
        ORDER BY 1 ASC, 2 ASC
 
-This query (Q3_) returns courses from the school of
+`This query`__ returns courses from the school of
 engineering having more than 3 credits.
 
-.. _Q3:
-     http://demo.htsql.org
-     /course?department.school='eng'&credits>3
+__ http://demo.htsql.org
+        /course?department.school='eng'&credits>3
 
 Paging and Sorting
 ------------------
       ORDER BY 4 ASC NULLS FIRST, 1 ASC, 2 ASC
       LIMIT 10 OFFSET 20
 
-This query (Q4_) returns courses 21 to 30 in the course
+`This query`__ returns courses 21 to 30 in the course
 catalog as sorted by number of credits.
 
-.. _Q4:
-     http://demo.htsql.org
-     /course.sort(credits).limit(10,20)
+__ http://demo.htsql.org
+        /course.sort(credits).limit(10,20)
 
 Aggregating Data
 ----------------
       )
       ORDER BY "school"."code" ASC
 
-This query (Q5_) returns, for each school having a
+`This query`__ returns, for each school having a
 MS program, the average number of courses offered
 across its departments.
 
-.. _Q5:
-     http://demo.htsql.org
-     /school{name,avg(department.count(course))}?
-          exists(program.degree='ms')
+__ http://demo.htsql.org
+        /school{name,avg(department.count(course))}
+                ?exists(program.degree='ms')
 
 
 What's up Next?
 
    .. sourcecode:: htsql
 
-      /program{degree^, count()}
+      /program{^degree, count(^)}
 
    .. sourcecode:: sql
 
       GROUP BY 1
       ORDER BY 1;
 
-This query (N1_) returns the number of programs per degree.
+`This query`__ returns the number of programs per degree.
 
-.. _N1:
-     http://demo.htsql.com
-     /program{degree^,count()}
+__ http://demo.htsql.org
+        /(program^degree){*,count(^)}
 
 Hierarchical Output
 -------------------
       AS d ON (s.code = d.school)
       ORDER BY s.code,d.code;
 
-This query (N2_) returns programs and departments
+`This query`__ returns programs and departments
 in each school.
 
-.. _N2:
-     http://demo.htsql.com
-     /school{name}/(program{title};department{name})
+__ http://demo.htsql.com
+        /school{name}/(program{title};department{name})
 
 More Backends
 -------------