On another thread I saw a answer to a sql problem using Oracle's analytics. Is there a equivalent in PostgreSQL or generic SQL?
在另一个线程上,我看到了使用Oracle分析的sql问题的答案。在PostgreSQL或通用SQL中是否有等价物?
2 个解决方案
#1
Alas.. and it sounds like they won't be in Postgres 8.4, either. They are under development, though.
唉..而且听起来他们也不会在Postgres 8.4中。不过,他们正在开发中。
Some useful functions can be found in this contrib: http://www.postgresql.org/docs/8.3/static/tablefunc.html (connect_by, crosstab)
在这篇文章中可以找到一些有用的函数:http://www.postgresql.org/docs/8.3/static/tablefunc.html(connect_by,crosstab)
#2
I'm not familiar with Oracle Analytics, but I've worked with Jasper Reports a little and I like it.
我不熟悉Oracle Analytics,但我和Jasper Reports有点合作,我喜欢它。
- Jasper Reports is a library that you can code against to run reports.
- Jasper Server lets you host your reports in a web app. It has security and scheduling.
- iReport is a GUI designer for Jasper and it can upload reports directly to Jasper Server.
- Jasper Analysis is for Analytics.
Jasper Reports是一个可以编写代码来运行报告的库。
Jasper Server允许您在Web应用程序中托管报表。它具有安全性和日程安排。
iReport是Jasper的GUI设计器,它可以直接将报告上传到Jasper Server。
Jasper Analysis适用于Analytics。
More here: http://www.jaspersoft.com/JasperSoft_JasperServer.html
更多信息:http://www.jaspersoft.com/JasperSoft_JasperServer.html
Most of the stuff is free, but there are commercial versions too.
大多数东西都是免费的,但也有商业版本。
#1
Alas.. and it sounds like they won't be in Postgres 8.4, either. They are under development, though.
唉..而且听起来他们也不会在Postgres 8.4中。不过,他们正在开发中。
Some useful functions can be found in this contrib: http://www.postgresql.org/docs/8.3/static/tablefunc.html (connect_by, crosstab)
在这篇文章中可以找到一些有用的函数:http://www.postgresql.org/docs/8.3/static/tablefunc.html(connect_by,crosstab)
#2
I'm not familiar with Oracle Analytics, but I've worked with Jasper Reports a little and I like it.
我不熟悉Oracle Analytics,但我和Jasper Reports有点合作,我喜欢它。
- Jasper Reports is a library that you can code against to run reports.
- Jasper Server lets you host your reports in a web app. It has security and scheduling.
- iReport is a GUI designer for Jasper and it can upload reports directly to Jasper Server.
- Jasper Analysis is for Analytics.
Jasper Reports是一个可以编写代码来运行报告的库。
Jasper Server允许您在Web应用程序中托管报表。它具有安全性和日程安排。
iReport是Jasper的GUI设计器,它可以直接将报告上传到Jasper Server。
Jasper Analysis适用于Analytics。
More here: http://www.jaspersoft.com/JasperSoft_JasperServer.html
更多信息:http://www.jaspersoft.com/JasperSoft_JasperServer.html
Most of the stuff is free, but there are commercial versions too.
大多数东西都是免费的,但也有商业版本。