sql - 返回非限定列名的 SELECT 语句

Question

我在管理这样的查询时遇到困难:

SELECT c.id, p.id FROM claim c, procedure p LIMIT 1;

此查询将返回以下集合:

 id | id
----+----
 49 |  1

有什么方法可以让它为列名返回c.id 和p.id 吗？这个不行:

SELECT c.id as c.id, p.id as c.id FROM claim c, procedure p LIMIT 1;

或者这是我的最终解决方案？

SELECT c.id as c_id, p.id as p_id FROM claim c, procedure p LIMIT 1;

Answer 1

SELECT c.id AS "c.id", p.id AS "p.id" FROM claim c, procedure p LIMIT 1;

或者简单地说:

SELECT c.id "c.id", p.id "p.id" FROM claim c, procedure p LIMIT 1;