Re: BUG #14140: over function not working in version 8.3 - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: BUG #14140: over function not working in version 8.3
Date
Msg-id CAFj8pRChkq7PHizZ3Z=FSwJNws8N8w9WroTGBaW2TE2tf8kmmw@mail.gmail.com
Whole thread Raw
In response to BUG #14140: over function not working in version 8.3  (anuj.srivastava@acsicorp.com)
List pgsql-bugs
Hi

2016-05-16 16:25 GMT+02:00 <anuj.srivastava@acsicorp.com>:

> The following bug has been logged on the website:
>
> Bug reference:      14140
> Logged by:          anuj srivastava
> Email address:      anuj.srivastava@acsicorp.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>

pgsql-bugs by date:

Previous
From: boniksoft@gmail.com
Date:
Subject: BUG #14141: Installation Failed
Next
From: Francisco Olarte
Date:
Subject: Re: BUG #14140: over function not working in version 8.3