Re: BUG #14140: over function not working in version 8.3

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: anuj(dot)srivastava(at)acsicorp(dot)com
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14140: over function not working in version 8.3
Date: 2016-05-16 16:26:01
Message-ID: CAFj8pRChkq7PHizZ3Z=FSwJNws8N8w9WroTGBaW2TE2tf8kmmw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi

2016-05-16 16:25 GMT+02:00 <anuj(dot)srivastava(at)acsicorp(dot)com>:

> The following bug has been logged on the website:
>
> Bug reference: 14140
> Logged by: anuj srivastava
> Email address: anuj(dot)srivastava(at)acsicorp(dot)com
> PostgreSQL version: Unsupported/Unknown
> Operating system: linux
> Description:
>
> Please give a solution to get working over function in 8.3
>

This is not bug. Window functions is not supported in too old PostgreSQL
releases.

Almost all functionality can be replaced by custom plpgsql srf function.

http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING

Regards

Pavel Stehule

>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Francisco Olarte 2016-05-16 16:26:07 Re: BUG #14140: over function not working in version 8.3
Previous Message David G. Johnston 2016-05-16 16:25:40 Re: BUG #14140: over function not working in version 8.3