Fix missing column names in queries in advanced.md (#347)
* add missing column name to `SELECT`
* more consistent capitalization of query terms
diff --git a/docs/advanced/advanced.md b/docs/advanced/advanced.md
index 9ef3ae6..8a0ee0f 100644
--- a/docs/advanced/advanced.md
+++ b/docs/advanced/advanced.md
@@ -8,12 +8,12 @@
```postgresql
-WITH graph_query as (
+WITH graph_query AS (
SELECT *
FROM cypher('graph_name', $$
MATCH (n)
RETURN n.name, n.age
- $$) as (name agtype, age agtype)
+ $$) AS (name agtype, age agtype)
)
SELECT * FROM graph_query;
```
@@ -71,13 +71,13 @@
```postgresql
SELECT id,
- graph_query.name = t.name as names_match,
- graph_query.age = t.age as ages_match
+ graph_query.name = t.name AS names_match,
+ graph_query.age = t.age AS ages_match
FROM schema_name.sql_person AS t
JOIN cypher('graph_name', $$
MATCH (n:Person)
RETURN n.name, n.age, id(n)
-$$) as graph_query(name agtype, age agtype, id agtype)
+$$) AS graph_query(name agtype, age agtype, id agtype)
ON t.person_id = graph_query.id
```
@@ -136,13 +136,14 @@
```postgresql
-SELECT t.name FROM schema_name.sql_person AS t
-where t.name = (
+SELECT t.name, t.age
+FROM schema_name.sql_person AS t
+WHERE t.name = (
SELECT a
FROM cypher('graph_name', $$
- MATCH (v)
+ MATCH (v)
RETURN v.name
- $$) as (name varchar(50))
+ $$) AS (name varchar(50))
ORDER BY name
LIMIT 1);
```
@@ -180,13 +181,14 @@
```postgresql
-SELECT t.name, t.age FROM schema_name.sql_person as t
-where t.name in (
+SELECT t.name, t.age
+FROM schema_name.sql_person AS t
+WHERE t.name IN (
SELECT *
FROM cypher('graph_name', $$
MATCH (v:Person)
RETURN v.name
- $$) as (a agtype));
+ $$) AS (a agtype));
```
@@ -235,13 +237,13 @@
```postgresql
SELECT t.name, t.age
-FROM schema_name.sql_person as t
+FROM schema_name.sql_person AS t
WHERE EXISTS (
SELECT *
FROM cypher('graph_name', $$
- MATCH (v:Person)
+ MATCH (v:Person)
RETURN v.name, v.age
- $$) as (name agtype, age agtype)
+ $$) AS (name agtype, age agtype)
WHERE name = t.name AND age = t.age
);
```
@@ -287,11 +289,11 @@
FROM cypher('graph_1', $$
MATCH (v:Person)
RETURN v.name, v.age
-$$) as graph_1(col_1 agtype, col_2 agtype, col_3 agtype)
+$$) AS graph_1(col_1 agtype, col_2 agtype, col_3 agtype)
JOIN cypher('graph_2', $$
MATCH (v:Doctor)
RETURN v.name, v.license_number
-$$) as graph_2(name agtype, license_number agtype)
+$$) AS graph_2(name agtype, license_number agtype)
ON graph_1.name = graph_2.name
```
