> On Wed, 07 Sep 2011 19:23:11 -0000, "Ronan Keating"<tanjuozgur@...>
> wrote:
>> --- In firebird-support@yahoogroups.com, Ann Harrison<aharrison@...>
>> wrote:
>>>
>>> 2011/9/7 Svein Erling Tysvær<svein.erling.tysvaer@...>
>>>
>>
>>>> Another thing is that I would recommend you not to use 'set
>>> Although Svein is almost always right about everything, in this case
> he's
>>> overgeneralized a good warning. Several things in the database
> metadata
>>> have limits on the number of times they can be modified, including the
>>> number of generators you can define, but resetting a generator leaves
> no
>>> traces and can be done as often as you wish.
>>>
>>> Good luck,
>>>
>>> Ann
>> Thank for your remarks,
>> but I've to overcome that hurdle, IMHO bottle-neck is that generator
> there
>> should be more elegant way for numbering the rows such as in MSSQL
>> row_number().
>
> That is planned for Firebird 3.0:
> http://tracker.firebirdsql.org/browse/CORE-2830

And already available in the snapshot builds.

Beside that, the new Firebird 3.0 "Window functions" are discussed in
the third part of my article series on Firebird 3.0 in the "Entwickler
Magazin" somewhere available in Mid October. The article is in German
though. ;-)


--
With regards,
Thomas Steinmaurer

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/