The following query executes without a problem on 8.4 but fails with
syntax error on 8.3. Is there a "new features" document which would
tell me the differences?

with emp1 as (select ename,
deptno,
rank() over
(partition by deptno order by sal) as salrank
from emp)
select ename,deptno,salrank from emp1 where salrank=1;




--
http://mgogala.byethost5.com

Mladen Gogala wrote on 23.11.2009 23:13:

http://www.postgresql.org/docs/curre...c/release.html

Mladen Gogala <no (AT) email (DOT) here.invalid> writes:

The manual has a release notes section (Appendix E) which generally
covers any changes, though how prominent a change is featured varies.

In this case, the WITH clause is mentioned in "E.2.3.3. Queries".

Window functions (the use of rank() and OVER in your query) are also
8.4 features (mentioned in E.2.1 and E.2.3.3), so you won't be able to
just replace the WITH clause with a sub-query under 8.3.x

-- David

On Mon, 23 Nov 2009 19:36:25 -0500, David Bolen wrote:

Bummer! I would have the developers use 8.4.1 a long time ago but one of
the developers told me that pljava is not supported with 8.4.1. I
installed the RPM packages for 8.4.1 from the download site but there is,
indeed, no pljava for 8.4.1. I will try compiling it from the source.



--
http://mgogala.byethost5.com