我有以下的PostgreSQL函数,它从一个表中返回多列数据:
它返回的结果如下所示:
CREATE OR REPLACE FUNCTION userbyid(id integer)
RETURNS TABLE(id int, username character varying(30), email character varying(254), last_login timestamp with time zone) AS
$$
SELECT
id,
username,
email,
last_login
FROM
auth_user
WHERE
id = $1;
$$
LANGUAGE 'sql';
它返回的结果如下所示:
userbyid
--------------------------------------------------------------
(2, smith, smith@example.com, "2017-06-04 19:47:49.472259+00")
是否有可能显示正确的列标题输出,类似于以下内容:
id username email last_login
--------------------------------------------------------------
2 smith smith@example.com 2017-06-04
我正在查看CREATE FUNCTION文档页面,但并不清楚如何操作。我也在网上搜索过,没有找到相关文章。
SELECT ar.invnumber as "发票号码", ar.amount as "发票总额", ar.transdate as "发票日期", customer.name as "客户名称", acc_trans.amount as "已收金额", acc_trans.transdate as "收款日期"
- guillouj