今天早上我遇到了一个奇怪的问题。我正在创建一个视图来简化 Postgres 表中的应用程序列表。
这失败了。
CREATE OR REPLACE VIEW application_view AS
SELECT COALESCE( nullif(full_name,''), nullif(additional_info,''), app_name) name
, id
FROM application
ORDER BY COALESCE( nullif(full_name,''), nullif(additional_info,''), app_name)
whereas
CREATE OR REPLACE VIEW application_view AS
SELECT COALESCE( nullif(full_name,''), nullif(additional_info,''), app_name) application
, id
FROM application
ORDER BY COALESCE( nullif(full_name,''), nullif(additional_info,''), app_name)
worked.
我经常使用 name 作为表中的列名,所以关于为什么第一个 sql 语句失败有什么想法吗?