关于postgresql数据库统计的问题,急!急!急!,在线等待
我用的是linux系统,APACHE PHP4,Postgresql数据库
1、怎么建立临时表
2、请看看下面的语句
SELECT dbecode AS name, dbecode AS b, dbdate AS a, dbjobnumber AS c,
dbworkid AS d, dbworktime AS e, dbcttribute AS f, memo AS g into #temp1
FROM tdreport
UNION ALL
SELECT dbecode AS name, '小计' AS b, '' AS a, '' AS c, '' AS d,
SUM(dbworktime) AS e, '' AS f, '' AS g
FROM tdreport
GROUP BY dbecode
ORDER BY name ,a desc
为什么提示:错误:pg_atoi:error in "小计":can't parse "小计"
我改成 ...dbecode as name,'' as b ... 也不行
则么解决???