Обсуждение: BUG #14140: over function not working in version 8.3
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDE0MApMb2dnZWQgYnk6ICAg ICAgICAgIGFudWogc3JpdmFzdGF2YQpFbWFpbCBhZGRyZXNzOiAgICAgIGFu dWouc3JpdmFzdGF2YUBhY3NpY29ycC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiBVbnN1cHBvcnRlZC9Vbmtub3duCk9wZXJhdGluZyBzeXN0ZW06ICAgbGlu dXgKRGVzY3JpcHRpb246ICAgICAgICAKClBsZWFzZSBnaXZlIGEgc29sdXRp b24gdG8gZ2V0IHdvcmtpbmcgb3ZlciBmdW5jdGlvbiBpbiA4LjMKCg==
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 >
On Mon, May 16, 2016 at 4:25 PM, <anuj.srivastava@acsicorp.com> wrote: > The following bug has been logged on the website: .... > Please give a solution to get working over function in 8.3 This does not seem like a bug. You may have more luck asking for advice ( with a little more detail of what you are trying to achieve ) in the psql-general list. Francisco Olarte.
On Mon, May 16, 2016 at 10:25 AM, <anuj.srivastava@acsicorp.com> wrote: > 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 > =E2=80=8BThis is not a bug and the version you are inquiring about is long = out of support.=E2=80=8B =E2=80=8BThat said: =E2=80=8B"over" is not a function - is a part of window expressions which w= ere introduced in 8.4 =E2=80=8BUpgrade or live without. David J.