| Subject | Re: little help to build a query in Firebird |
|---|---|
| Author | Ronan Keating |
| Post date | 2011-09-07T19:23:11Z |
--- In firebird-support@yahoogroups.com, Ann Harrison <aharrison@...> wrote:
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().
>Thank for your remarks,
> 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
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().