Search code examples
postgresqlpostgresql-9.4rollup

No ROLLUP and CUBE in PostgreSQL 9.4?


I have some queries containing rollup and cube statements. When I run them on a computer with PostgreSQL 9.4 and PgAdmin III, it says that such functions don't exist. The same queries clearly have worked on another computer with PgAdmin III.


Solution

  • Indeed. ROLLUP and CUBE were only introduced in PostgreSQL 9.5 - see the release notes.