postgresql - 在 PostgreSQL 中创建 View 时出错

Question

代码如下:

CREATE OR REPLACE VIEW skats_4 AS SELECT count(datums) AS 
2014_gada_pieteikumi from pieteikums where date_part('YEAR', 
datums)=2014;

我不断收到文本“2014 年附近的语法错误”(“2014_gada_pieteikumi”)的错误。我看不出有什么问题。

Answer 1

标签不应以数字开头。使用双引号或重命名标签

postgres=# select 10 as 2014_some;
ERROR:  syntax error at or near "2014"
LINE 1: select 10 as 2014_some;
                     ^
Time: 0.647 ms
postgres=# select 10 as "2014_some";
 2014_some 
───────────
        10
(1 row)