Subject Re: [firebird-support] Serial number in a query result
Author Jaison Joseph
On 25-03-2011 12:02 PM, Thomas Steinmaurer wrote:
>>> A throw-away SEQUENCE would also do the trick, I think:
>>> sql> create sequence AdHoc;
>>> sql> select next value for AdHoc as SrNo, d.* FROM (...) d;
>>> -Mike
>> This is exactly what I want.
> Needless to say, if the generator/sequence is used by multiple users,
> then this isn't safe.
And also, it will exhaust after 32000 queries am i right (if a new
sequence is used every time)?