Author: mariuz

From twitter

I remember when I added the LOWER function to Firebird. I needed to grep (for nod_upper) and change dozens of files…
Now to add even a window function (which the framework is prepared to) it takes just a few localized changes http://bit.ly/uAt3ZP…
Now adding LAST_VALUE and NTH_VALUE.

You can read more about the list of window functions that are already implemented or needs to be implemented on the tracker

A short description of what these functions do :

first_value(value any) return value evaluated at the row that is the first row of the window frame
last_value(value any) returns value evaluated at the row that is the last row of the window frame
nth_value(value any, nth integer) returns value evaluated at the row that is the nth row of the window frame (counting from 1); null if no such row
for ref : http://www.postgresql.org/docs/9.1/static/functions-window.html#FUNCTIONS-WINDOW-TABLE

I see a new Improvement on the feature requests list , any comments ?

http://tracker.firebirdsql.org/browse/CORE-3642

The List of talks for Firebird Conference 2011 is now online

http://firebirdsql.org/en/firebird-conference-2011/

Firebird 2.5.1 Final packages are available in Debian Sid repository

The various command line manuals – gfix, gstat, gsec, gbak and fbmgr – have been updated to Firebird 2.5 specification. In the case of fbmgr it was only a few spelling mistakes that were corrected.
I’ve uploaded the html and pdf versions to the online repository. One thing I noticed when testing, the PDFs are ok but the HTML files seem to need a refresh on every page. Has anyone else noticed this when a new HTMl documents is uploaded?
Try hitting this link and see if you get the 11 October 2011 version:
If you don’t see 11 October 2011, click refresh. Now click on the link to go to Command Line Options. Under the password option do you see a fetch_password option? If not, click refresh.

I found this morning that I had to manually refresh every page in each of the updated manuals – which I’ve never had to do before.

Cheers,
—
Norman Dunbar

Firebird Project is happy to announce general availability of Firebird 2.5.1 This sub-release introduces several bug fixes and many important improvements – for example, performance improvements during a database restore, the ability to write to global temporary tables in read-only databases, etc. For the full list of changes please refer to the Release Notes, Chapter 2 “New in Firebird 2.5”. Firebird 2.5.1 has 100% compatible on-disk structure with Firebird 2.5.0, so it is recommended to migrate to 2.5.1 as soon as possible.

There is a substantial number of bug fixes, this sub-release takes in a few minor improvements and optimizations that missed the initial release. In summary: