Re: Postgres 8.4

Lists: pgsql-general
From: Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>
To: Yasser Shakoor <yassershakoor(at)gmail(dot)com>
Cc: PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres 8.4
Date: 2009-11-30 07:34:28
Message-ID: e08cc0400911292334w797f08eeh1acbd7a2a1c501df@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

2009/11/29 Yasser Shakoor <yassershakoor(at)gmail(dot)com>:
> Hi
> I am using postgres 8.4 but couldnot able to use the OLAP functionality can
> you please advice do i have apply any patch for this.
> I am using postgres on windows and downloaded the latest version from
> Enterprise DB site.
> Regards,
> Yasser

What exactly is "OLAP functionality" you mention? You can use window
function from 8.4 on:

SELECT row_number() OVER () FROM tbl;

Regards,

--
Hitoshi Harada