Implicit aliasing of table not allowed. Use explicit
AS clause1select sum(a) over w, avg(b) over (partition by c order by d rows e preceding), min(f) over (order by g range between unbounded preceding and h following exclude ties) from t window w as (partition by i groups between j preceding and current row exclude no others)Implicit aliasing of table not allowed. Use explicit
AS clause38) i
39 ON (ct.oid = i.indrelid)
40JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid)
41JOIN pg_catalog.pg_am am ON (ci.relam = am.oid)42WHERE TRUE
43 AND n.nspname = 'public'
44 AND ct.relname = 'j'Implicit aliasing of table not allowed. Use explicit
AS clause37 FROM pg_catalog.pg_index i
38) i
39 ON (ct.oid = i.indrelid)
40JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid)41JOIN pg_catalog.pg_am am ON (ci.relam = am.oid)
42WHERE TRUE
43 AND n.nspname = 'public'Implicit aliasing of table not allowed. Use explicit
AS clause35 i.indexprs,
36 information_schema._pg_expandarray(i.indkey) AS KEYS
37 FROM pg_catalog.pg_index i
38) i39 ON (ct.oid = i.indrelid)
40JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid)
41JOIN pg_catalog.pg_am am ON (ci.relam = am.oid)Implicit aliasing of table not allowed. Use explicit
AS clause34 i.indpred,
35 i.indexprs,
36 information_schema._pg_expandarray(i.indkey) AS KEYS
37 FROM pg_catalog.pg_index i38) i
39 ON (ct.oid = i.indrelid)
40JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid)Implicit aliasing of table not allowed. Use explicit
AS clause24 ci.relpages AS pages,
25 pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition
26FROM pg_catalog.pg_class ct
27JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid)28JOIN (
29 SELECT i.indexrelid,
30 i.indrelid,Implicit aliasing of table not allowed. Use explicit
AS clause23 ci.reltuples AS CARDINALITY,
24 ci.relpages AS pages,
25 pg_catalog.pg_get_expr(i.indpred, i.indrelid) AS filter_condition
26FROM pg_catalog.pg_class ct27JOIN pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid)
28JOIN (
29 SELECT i.indexrelid,
Description
Implicit aliasing of table not allowed. Use explicit AS clause.
Bad practice
In this example, the alias ‘voo’ is implicit.
SELECT
voo.a
FROM foo voo
Recommended
Add AS to make it explicit.
SELECT
voo.a
FROM foo AS voo
Ref: https://stackoverflow.com/questions/4164653/whats-the-purpose-of-sql-keyword-as