There is a rand function in ib_udf, though I've never used it
(thinking about it, I do some randomization in client software, maybe
I should let Firebird take over that part? Thanks for the idea!).

Set

--- In firebird-support@yahoogroups.com, "Gediminas" wrote:
> using SP, UDF or other FB 1.5 features need to implement function,
> which randomly orders dataset (get from the select statement) using
> iterative algorithm (actually, every function call reorders element
> position in the set).
> As I know, the FB doesn't have set or list containers as in the STL.
> Is it possible to use table as a temporary container, but if several
> concurent calls to such function would occur?