关于postgresql数据库统计的问题，急！急！急！，在线等待

[huoniao1976]

我用的是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 ... 也不行
则么解决？？？

[lyyrw]

Postgresql数据库不支持select...into...
可以用insert into ... select ...代替

[sunthing]

Post对临时表回收很慢，几十年都不收回！不如用子查询！

[lyyrw]

不知道解没解决，你可以这样：
SELECT dbecode AS name, dbecode AS b, dbdate AS a, dbjobnumber AS c,
dbworkid AS d, dbworktime AS e, dbattribute AS f, memo AS g into temp1
FROM tbreport
UNION ALL
SELECT dbecode AS name, '12' AS b,'1900-01-01' AS a, '13' AS c, '14' AS d,
SUM(dbworktime) AS e, '15' AS f, 'g' AS g
FROM tbreport
GROUP BY dbecode
UNION ALL
SELECT '22' as name, '20' AS b, '1900-01-01' AS a,'23' AS c, '24' AS d,
SUM( dbworktime) AS e, '25' AS f, 'g' AS g FROM tbreport ORDER BY name,a desc