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

huoniao1976 2003-08-22 01:26:09
我用的是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 ... 也不行
则么解决???
...全文
78 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
lyyrw 2003-09-03
  • 打赏
  • 举报
回复
不知道解没解决,你可以这样:
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
sunthing 2003-08-23
  • 打赏
  • 举报
回复
Post对临时表回收很慢,几十年都不收回!不如用子查询!
lyyrw 2003-08-23
  • 打赏
  • 举报
回复
Postgresql数据库不支持select...into...
可以用insert into ... select ...代替

56,675

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧